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

Latest Blog Posts

Registrant Job Title Data from SQLSaturday Baton Rouge events 2014-2016

In a blog post on the Sparkhound website, I laid out the strong case for a sponsor's Return on Investment (ROI) for sponsoring local SQLSaturday events. Part of my argument in favor of sponsoring SQLSaturday events are the diversity of attendees and their responsibilities, and particularly, the presence of…

Read more

0 comments, 121 reads

Posted in SQL Tact on 21 June 2017

dbatools at #SQLSatDublin

This weekend SQL Saturday Dublin occurred. For those that don’t know SQL Saturdays are free conferences with local and international speakers providing great sessions in the Data Platform sphere.

Chrissy LeMaire and I presented our session PowerShell SQL Server: Modern Database Administration with dbatools. You can find slides and… Read more

0 comments, 189 reads

Posted in SQL DBA With A Beard on 21 June 2017

How to use Python in SQL Server 2017 to obtain advanced data analytics

On the 19th of April 2017, Microsoft held an online conference called Microsoft Data Amp to showcase how Microsoft’s latest innovations put data, analytics and artificial intelligence at the heart of business transformation. Microsoft has, over the last few years, made great strides in accelerating the pace of innovation… Read more

0 comments, 255 reads

Posted in PowerSQL By Prashanth Jayaram on 20 June 2017

Speaking at the Data Platform Summit 2017

I am honored to be speaking at the Data Platform Summit 2017. The event takes place August 17-19, 2017 in Bangalore, India. This will be my first trip to India, and I’m excited to be traveling halfway around the world (literally 12:30 hours difference) to speak at this event. Read more

0 comments, 181 reads

Posted in The Voice of the DBA on 20 June 2017

Power BI Custom Visuals Class (Module 56 – Rotating Tile)

In this module you will learn how to use the Rotating Tile Custom Visual.  The Rotating Tile gives you the ability to display multiple metrics on a single visual that rotates through each value you wish to display.  This allows you to save valuable space on your reports!

Module 56…

Read more

1 comments, 137 reads

Posted in Devin Knight on 20 June 2017

Database Fundamentals #3: What’s In a Database?

It’s worth noting that a lot of people will never need to create their own database. You may never create your own tables or other data structures either. You may only ever run backups and restores and manipulate the security on the system and let application installs create databases for… Read more

2 comments, 112 reads

Posted in The Scary DBA on 20 June 2017

Statistics and Cardinality Estimation


This is a term originally from Mathematics, generally defined as “The number of objects in a given set or grouping”. In SQL we’re continually dealing with sets so this becomes a very relevant topic, which in our context is just the “number of rows”.

When you have a query… Read more

0 comments, 117 reads

Posted in Matthew McGiffen DBA on 20 June 2017

How the Initial VLF sequence number gets decided of the default transaction log file

In last three years, I presented two times on the topic Transaction Log File Architecture. During the sessions, when I discussed the undocumented command DBCC LOGINFO, one of the common questions which I got – ‘How the Initial VLF sequence number gets decided of the default transaction log file’?… Read more

0 comments, 114 reads

Posted in SQL Geek on 20 June 2017

DevOps – Downloading a File from the Internet with PoSh

One of the things we need to do as data professionals is move data files around. Often we’ll get a local path, but in looking for public data sets, I wanted to get a file from the Internet. In this case, a rather large file.

I could have put the… Read more

1 comments, 174 reads

Posted in The Voice of the DBA on 19 June 2017

PASS Security VC Presentation – The Dirty Business of Auditing

On Thursday, June 22, at 1 PM EDT / 10 AM PDT, I’ll be presenting for the PASS Security Virtual Chapter.

Registration Link

Here’s what I’ll be speaking on:

The Dirty Business of Auditing

Auditing is often a dirty word among DBAs because it equates to more work with… Read more

0 comments, 94 reads

Posted in Databases – Infrastructure – Security on 19 June 2017

dbfs – command line access to SQL Server DMVs

With SQL Server on Linux, Microsoft has recognized that they’re opening up their products to a new set of users. People that aren’t used to Windows and it’s tools. In the Linux world we have a set of tools that work with our system performance data and present that to… Read more

0 comments, 192 reads

Posted in Anthony Nocentino's Blog on 19 June 2017

The Three T’s of Backups

I just read several more horror stories that include, among other things, failed backups. I’ve said it before (at volume, extreme volume), and evidently I have to say it again. Simply creating a backup file is not enough to ensure the protection of your information. In… Read more

5 comments, 130 reads

Posted in The Scary DBA on 19 June 2017

Webinar with Rubrik: Simplifying SQL Server Data Protection – Near Zero RTO

I am very proud to contribute to a new webinar with Rubrik on Thursday, June 22 at 8AM PT / 11AM ET where we talk about the trials and tribulations of living as a Database Administrator and the challenges when handling SQL Server backups with the same tools as a… Read more

0 comments, 84 reads

Posted in Technobabble by Klee from @kleegeek on 19 June 2017

SQL Server TDE – Is TempDB Encrypted?

A really quick one today, something that made me think for a minute and I thought it might make others think too. So you have enabled TDE  – Transparent Data Encryption (you can see these previous posts here: https://blobeater.blog/?s=tde&submit=Search) on your SQL … Continue reading

Read more

1 comments, 120 reads

Posted in All About SQL on 19 June 2017

Adding Identity to an existing column

A friend had an interesting problem today. A really big table (multiple millions of rows) and no primary key. He then ran into an issue where he had to have one. The easiest thing is to create a new int column with an identity column right? Unfortunately in this case… Read more

1 comments, 127 reads

Posted in SQLStudies on 19 June 2017

Microsoft Professional Program in Data Science – Continued

A couple of weeks back I blogged about my progress in the “Microsoft Professional Program in Data Science” curriculum. I’ve now finished the remainder of the courses. Now I only need to finish the capstone project. This project only occurs at the start of each quarter and runs for a… Read more

0 comments, 186 reads

Posted in Koen Verbeeck on 19 June 2017

Understanding Relative Risk – with T-SQL

In this post we will explore a common statistical term – Relative Risk, otherwise called Risk Factor. Relative Risk is a term that is important to understand when you are doing comparative studies of two groups that are different in some specific way. The most common usage of this is… Read more

0 comments, 1,203 reads

Posted in Mala's Data Blog on 19 June 2017

Monday Coffee – SQL Saturday Dublin

Last weekend was SQL Saturday Dublin, and it was a good one.

My session on An introduction to SQL Server & Containers was the first one of the day, scheduled for 8am; now for me that’s great as I tend to get a bit nervous beforehand so having the… Read more

0 comments, 97 reads

Posted in The DBA Who Came In From The Cold on 19 June 2017

PASS Board Elections

Well, it is almost that time of the year again. Elections for the PASS Board.

This is a great way to show your passion for this wonderful community of SQL Server or now, Microsoft Data Professionals. It looks like it is getting harder and harder for someone to come up… Read more

0 comments, 106 reads

Posted in The Smiling DBA on 19 June 2017

Great to see you at SQLSaturday Houston 2017

Great to see all of you at #SQLSatHouston today, an awesome event put on by a great crew of volunteers. I presented in the first timeslot of a stacked schedule, and met and made a lot of friends.

My talk on SQL Server Permissions and Security Principals had a…

Read more

0 comments, 90 reads

Posted in SQL Tact on 17 June 2017

Newer posts

Older posts