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

Latest Blog Posts

Extract the File Name in SSIS Data Flows using the FileNameColumnName Property

When extracting data from a flat file, it is handy to have the name of the file from which the data was retrieved. Whether you capture this information for auditing purposes, or you include it directly in the output table, the odds are good that you’ll want to have that… Read more

0 comments, 17 reads

Posted in Tim Mitchell on 15 December 2018

Azure Backup Storage Options

As a database administrator, I am very conscious of how data is being backed up.  Up until SQL Server 2012, you were limited to backing up your databases to a physical device.  That device could be a tape, local disk, or network storage.  After successfully creating a backup, if you’re… Read more

2 comments, 98 reads

Posted in John Morehouse | Sqlrus.com on 14 December 2018

The Year in Review Webinar–Dec 18

Join me for our Year in Review Webinar next week, Dec 18, at 4pm GMT. I’ll be joining Kendra and Grant to talk through what happened this year, and make a few predictions for 2019.

It should be fun, festive, maybe a bit silly, but a good break in your… Read more

0 comments, 97 reads

Posted in The Voice of the DBA on 14 December 2018

Synonyms in SQL Server – Good and Bad

When SQL Server 2005 was released, a nifty little feature was included called synonyms.  Despite being around since SQL Server 2005, I think this feature is often under-utilized or, more importantly, it is implemented in a very bad way.

Today I want to share a couple of examples.  We will… Read more

0 comments, 88 reads

Posted in SQL RNNR on 14 December 2018

Fun time Friday - A week is a long time in....

A week is a long time in...

SQL Server Land

A week is a long time in SQL Server land. This week I have been busy working on a version migration for one particular customer and looking at security, 'productionising' some servers and troubleshooting connectivity issues for another. As is…

Read more

0 comments, 50 reads

Posted in The SQL DBA in the UK on 14 December 2018

ASF 017: Alex Whittles interview

Introduction Alex Whittles is the owner and principle consultant at Purple Frog, a SQL Server Business Intelligence consultancy in the UK with multinational clients in a variety of sectors. He specialises in all aspects of dimensional data modelling, data warehousing, ETL and cubes using the SQL Server stack.Alex has an… Read more

0 comments, 69 reads

Posted in SQL Player Blog on 14 December 2018

Setting up CentOS to run docker for SQL Server

This blog post is about running SQL Server in a docker container on CentOS Linux distribution.

This was both an experiment and also for me to re-learn CentOS – years ago I had done a fair bit with CentOS – back when I was a true Operations Consultant. Up until… Read more

0 comments, 91 reads

Posted in The Hybrid DBA's Blog on 13 December 2018

Maintenance Plan Owner – Back to Basics

We all inherit things from time to time through our profession.  Sometimes we inherit some good things, sometimes we inherit some things that are not so good.  Other times we inherit some things that are just plan annoying.  Yet other times, we inherit things that may be annoying and we… Read more

0 comments, 98 reads

Posted in SQL RNNR on 13 December 2018

Power BI Monthly Digest – December 2018

In this month’s Power BI Digest with my friend Manuel Quintana [Blog | Twitter] and I will again guide you through some of our favorite Power BI updates this month. In our December 2018 edition we highlighted the following features:

  • Smart Guides
  • Field List keyboard shortcuts
  • Control Tab…

Read more

0 comments, 204 reads

Posted in Devin Knight on 13 December 2018

Difference between Restore with Recovery & Restore with Norecovery

Every tech-conscious person is familiar with restoration process in the world of computing. This process is usually followed by the process of backup. In case of SQL Server, restoration procedure means copying the backup and move it to the recovery point. SQL Database recovery involves rolling forward uncommitted transactions and… Read more

0 comments, 69 reads

Posted in Ganapathi's MSSQLLover on 13 December 2018

Change Tracking Inserts Require SELECT Permission

I’ve been writing about change tracking in SQL Server for some time now, but I recently came across a permissions issue on a change tracking table that I’d never encountered before. When attempting to insert data into a change tracking-enabled table using an account with no select permissions, I learned… Read more

0 comments, 85 reads

Posted in Tim Mitchell on 13 December 2018

Things I Learned at Summit v20 - Visual Studio Code

Part of a series of posts on cool stuff I learned at PASS Summit v20 (2018) - in this post we'll look at a code editing tool that I hadn't seen before - Visual Studio Code.


When I attend a session at a technical event - Summit/SQL Saturday/etc. -…

Read more

0 comments, 92 reads

Posted in Nebraska SQL from @DBA_ANDY on 13 December 2018

Setting up SQL Server replication in containers

Last week I saw a thread on twitter about how to get replication setup for SQL Server running in a container. Now I know very little about replication, it’s not an area of SQL that I’ve had a lot of exposure to but I’m always up for figuring stuff out… Read more

0 comments, 95 reads

Posted in The DBA Who Came In From The Cold on 13 December 2018

The Default Frame for Window Functions

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.

This bites me constantly, and I was reminded of this while watching Kathi talk at #SQLintheCity. When you write a Window function, there is an implicit… Read more

1 comments, 139 reads

Posted in The Voice of the DBA on 13 December 2018

Naming Convention Hall of Shame

Call me pedantic, but I can be a stickler for standardized naming conventions. Whether it’s application code, database objects, documentation, or other digital assets, I find a tremendous amount of value in establishing a set pattern for naming and formatting. Especially for organizations with a large digital landscape, having a… Read more

4 comments, 97 reads

Posted in Tim Mitchell on 13 December 2018

The Eleven Days of Festivus 2018

It’s that time again! My Eleven Days of Festivus blogging extravaganza is now in its third year, and I’m happy to share one blog post per day with you for the 11 days between now and Festivus Eve (December 22nd). As before, I’ll link all of the posts from this… Read more

0 comments, 83 reads

Posted in Tim Mitchell on 13 December 2018

SSMS – Docker SQL Server

once we install SQL Server on Docker which we discussed in our last blog, we can connect Docker SQL Server on Linux to SSMS on you local system, in my case it is windows Pro 10. I have installed SSMS … Continue reading

Read more

0 comments, 129 reads

Posted in Vinay Thakur on 13 December 2018

Some differences with SQL Server when running on AWS RDS

If you plan on using Amazon Web Services (AWS) to host your SQL Server based applications in the cloud, then you have a couple of options.

One is just to have an EC2 instance (a VM) and install the versions of the OS and SQL Server you want. There are… Read more

1 comments, 188 reads

Posted in Matthew McGiffen DBA on 12 December 2018

Some databases may show a NULL collation in the sys.databases DMV

While working on my Swart’s Ten Percent Rule post last week, I needed to test the Windows version of the script on my SQL Server 2016 instance. Just before removing all the databases, I noticed something interesting when querying the sys.databases Dynamic Management View (DMV). Because the process I had… Read more

0 comments, 92 reads

Posted in Born SQL with Randolph West on 12 December 2018

Bulk insert and an identity column

TL;DR; BULK INSERT doesn’t have an easy way to specify a column list so the columns in the insert file must match the columns in the table unless you use a format file or a staging table.

As simple as they appear on the surface identity columns are fairly complicated… Read more

0 comments, 124 reads

Posted in SQLStudies on 12 December 2018

Older posts