When issue is not exactly "issue"

In last release of SQL Code Guard (2.4.5222) I've added few issues which can cause confusion.Eg - ST012 "Consider using temporary table instead of...

New Permissions in SQL Server 2014: IMPERSONATE ANY LOGIN, SELECT ALL USER SECURABLES, CONNECT ANY DATABASE and the old CONTROL SERVER

(DE)
SQL Server 2014 bringt insgesamt 5 neue Berechtigungen. Zwei von diesen sind auf Datenbank-Ebene und nur in der Windows...

DAX #1 – Learning DAX

I recently attended a virtual training of Tabular and Power Pivot for Developers taught by Kathy Vick at Pragmatic Works....

Friday Followup For April 25, 2014

It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...

From where does SSMS get its database defaults?

We can create a database simply by typing in the command createdatabase DB1

We don’t have to provide any other...

Out for a day

I’m hoping I’m only out for a day. As I write this, I’ll be recovering from my ACL surgery, though...

Powershell Goodies

If you haven’t seen some of the other blog post, or the Microsoft Powershell Blog, Microsoft recently release Script Browser for...

Reblog: April 18 to April 24

Photo credit – JStove
Old posts are like unicorns. You might see them just once, but it’d sure be nice to have...

Why does my Failover Cluster Instance Keep Failing Back and Forth?

A few months ago I was paged by a client because their SQL Server Failover Cluster Instance (FCI) was experiencing...

Another Question Of the Day

Yesterday I submitted a new question of the day based on the best idea generator you can find – something that...