-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Latest Blog Posts

Overview of File-group(s) and Piecemeal database restore operations in SQL Server

So far, we discussed many de-facto details about SQL Server database backup and restore. In this 15th article of the series, we are going to discuss, the file-group and piecemeal database backup and restore process.

Database “Backup and Restore” strategies are vital to every organization for smoother… Read more

0 comments, 456 reads

Posted in PowerSQL By Prashanth Jayaram on 22 June 2018

Speaking This Weekend in Iowa City!

Come out to SQL Saturday Iowa at the University of Iowa this Saturday 06/23/2018 for a SQL Saturday that never disappoints - Iowa always puts on a fun event with great atmosphere and informative sessions.

I am giving the premiere of my new presentation "Intro to Powershell for the…

Read more

0 comments, 161 reads

Posted in Nebraska SQL from @DBA_ANDY on 21 June 2018

New Session: Profiling Your Data

Data Quality is a huge issue, especially now with more and more data being created daily.  According to Micro Focus back in 2016, we were creating 44 Billion GB of data per day and are expected to produce 463 Billion GB of data per day by 2025.  That’s a LOT… Read more

0 comments, 69 reads

Posted in SQL Swimmer on 20 June 2018

Updating to SQL Change Automation

The SQL Change Automation release was early this week.  This is replacing ReadyRoll and our DLM Automation products, rolling them into a single product and is the first stage of unifying our state and migration based solutions.

When I logged into Visual Studio and checked updates this week, I found… Read more

0 comments, 230 reads

Posted in The Voice of the DBA on 20 June 2018

Dates and Times in SQL Server: DATENAME()

Last time we looked at DATEPART(). This post is all about the DATENAME() function. So many similarities There are many similarities between DATEPART and DATENAME. Where DATEPART returns the date or time part as an integer, DATENAME returns the part as a character string. This DATENAME function also takes two… Read more

0 comments, 239 reads

Posted in Born SQL with Randolph West on 20 June 2018

SSMS reset window layout (Day 37)

SSMS is a wonderful tool. You can drag Windows around, grouped with others, split, docked, undocked, hidden… it seems endless what you can do with them. You can even change what columns you see. Invariably, with all of this customization, things go wonky. I’ve even seen windows opened up… Read more

0 comments, 152 reads

Posted in A Discussion of SQL Server-Related Topics on 20 June 2018

Overview of SQL Server 2017 Docker containers on Linux machine

SQL Server 2017 is the biggest release and most important releases in the Microsoft product history simply because of the freedom that it gives to install the product anywhere. The advent of the Docker containers and growing emphasis on open source solutions opened the door to greater technological innovation and… Read more

2 comments, 630 reads

Posted in PowerSQL By Prashanth Jayaram on 20 June 2018

Strings vs Identifiers

A common mistake, and one I make frequently myself is to use a string in place of an identifier, or vise-versa. So to start, let’s have some definitions, shall we?

String

a linear sequence of characters, words, or other data.

Identifier

a sequence of characters used to identify or refer…

Read more

3 comments, 607 reads

Posted in SQLStudies on 20 June 2018

Replication Max Text Length

Ever seen the below error? Until this week I hadn’t. So, I figured I’d take a little time and introduce it to those that had not.

Error Description: Length of LOB data (65754) to be replicated exceeds configured maximum 65536. Use the stored procedure sp_configure to increase the configured maximum… Read more

2 comments, 484 reads

Posted in SQLEspresso on 20 June 2018

Deploying to Azure Without Writing JSON Arm Templates

Reading Time: 6 minutes (not a minute longer) TLDR; ARM templates are a great way to deploy to Azure, setting up a template that can deploy an entire environment from databases to web servers and load balancers to firewalls (damn you azure, ok, I’ll call it an nsg) is satisfying…

Read more

0 comments, 121 reads

Posted in Ed Elliott's Sql Developer Blog on 19 June 2018

Deploying to Azure Without Writing JSON Arm Templates

Reading Time: 6 minutes (not a minute longer) TLDR; ARM templates are a great way to deploy to Azure, setting up a template that can deploy an entire environment from databases to web servers and load balancers to firewalls (damn you azure, ok, I’ll call it an nsg) is satisfying…

Read more

0 comments, 172 reads

Posted in Ed Elliott's Sql Developer Blog on 19 June 2018

SQL Saturday Houston is this weekend

I’m speaking along with many other amazingly talented professionals, including Adam from Guy In A Cube. If you’re in the Houston, TX area be sure to head over to the SQL Saturday website to register. You can find more details here:  http://www.sqlsaturday.com/766/eventhome.aspx 

There are over 50 sessions across… Read more

0 comments, 124 reads

Posted in Confessions of a Microsoft Addict on 19 June 2018

Verify Allocation Unit Size for SQL Server

Why Do I Care? Everything in SQL Server is stored on disk in 8K pages.  The Microsoft recommended best practice is to format using a 64K allocation unit size.  Processes such as the checkpoint and Lazy Writer try to write in extents when possible.  Extents are a collection of 8… Read more

10 comments, 228 reads

Posted in Ryan Adams on 19 June 2018

South Florida Vacation Notes

I extended my trip to SQLSaturday South Florida for a couple days vacation. If I’m going to drive 3-1/2 hours may as well make the most of it.

Read more

0 comments, 116 reads

Posted in SQLAndy on 19 June 2018

Installing SSDT for Visual Studio 2017

I had SSDT for VS 2017 installed some time ago, but due to some issues I had to uninstall it. I also have SSDT for VS 2015 installed, as an add-on in Visual Studio 2015 Enterprise (because that’s the only way to get TFS working in VS 2015). I… Read more

0 comments, 591 reads

Posted in Koen Verbeeck on 19 June 2018

Join Elimination: When SQL Server Removes Unnecessary Tables

In this post and video at SQLPerformance.com, I discuss what join elimination is and how it works in SQL Server.  Join elimination is one of the many techniques that the SQL Server query optimizer uses to create efficient query plans. Specifically, join elimination occurs when SQL Server can establish… Read more

0 comments, 177 reads

Posted in Bert Wagner on 19 June 2018

SQL Server 2017 – SELECT INTO [A SPECIFIC FILEGROUP]

Forget about Adaptive Query Processing for a minute, what other feature have I been waiting for? SELECT INTO a specific filegroup, not the default filegroup! I have needed this feature many times in the past. Let’s take a look at it using the WideWorldImportersDW database.

SELECT INTO [A SPECIFIC FILEGROUP] Read more

1 comments, 192 reads

Posted in All About SQL on 19 June 2018

What Twitter Account Should SQLSaturday Use?

Last week PASS sent out an email saying that on June 15 all the tweets from @sqlsat would be changed to come from @sqlpass (and no more “attending” tweets”). The next day the deadline was moved to June 22 in response to feedback. You can read the official post here Read more

0 comments, 131 reads

Posted in SQLAndy on 18 June 2018

Analytics Platform System (APS) AU7 released

The Analytics Platform System (APS), which is a renaming of the Parallel Data Warehouse (PDW), has just released an appliance update (AU7), which is sort of like a service pack, except that it includes many new features.

Below is what is new in this release:

Customers will get… Read more

0 comments, 159 reads

Posted in James Serra's Blog on 18 June 2018

Analytics Platform System (APS) AU7 released

The Analytics Platform System (APS), which is a renaming of the Parallel Data Warehouse (PDW), has just released an appliance update (AU7), which is sort of like a service pack, except that it includes many new features.

Below is what is new in this release:

Customers will get… Read more

0 comments, 82 reads

Posted in James Serra's Blog on 18 June 2018

Older posts