T-SQL Tuesday – Folks Who Have Made a Difference #TSQL2sday
So this month’s T-SQL Tuesday subject is a shout out and high-five to those people who have inspired or made a...
2017-11-14
298 reads
So this month’s T-SQL Tuesday subject is a shout out and high-five to those people who have inspired or made a...
2017-11-14
298 reads
Recently I’ve been thinking about Python and whether it can be useful to the DBA as well as the data...
2017-10-30
383 reads
SQL Server tracks untrusted Foreign keys in sys.Foreign keys with a column called is_not_trusted, there may be a number of...
2017-10-24
162 reads
SQL Server’s integration of Python has been heavily marketed towards the machine learning and BI guys, but does it offer...
2017-10-18
646 reads
I’m pretty sure that we’ve all found ourselves in the situation where we’ve run an INSERT, UPDATE or DELETE script...
2017-10-05
160 reads
Routine maintenance rolls around and it’s time to failover your AG’s to new Primary’s to allow for patching and restarts…...
2017-10-04
297 reads
This is a reblog of a post that I originally wrote back in January. After using this technique again last...
2017-10-03
120 reads
It wasn’t until recently that i paid attention to truncation during concatenation, but that’s because whenever I used concatenation before...
2017-09-27
1,193 reads
As the famous Bard once said, “To disable indexes or not to disable indexes, that is the question?”. Well maybe...
2017-09-25
144 reads
How many times have you seen SQL Agent jobs with random ownership? It can be very frustrating when you are...
2017-09-25
162 reads
By Zikato
Foreword A picture is worth a thousand words. I use screenshots daily, whether it’s to...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
DBCC CLONEDATABASE is one of those features that I don’t use often but it’s...
I inherited a fairly large system with a couple dozen servers (1/4 physical, the...
Comments posted to this topic are about the item Python in Power BI
Comments posted to this topic are about the item Metrics that matter for IT...