Creating a SQL Server Test Lab On Your Workstation – Part One, Installing The Domain Controller
One of the most useful tools to the DBA when we need to test new features, recreate a fault that...
2017-12-18
644 reads
One of the most useful tools to the DBA when we need to test new features, recreate a fault that...
2017-12-18
644 reads
The slides and demo scripts from today’s GroupBy session are now available on our GitHub repository
https://github.com/SQLUndercover/UndercoverToolbox/tree/master/GroupBy
Many thanks again for watching,...
2017-12-08
353 reads
Now I’m all for making my life easier and one thing that makes life easier for me is having a...
2017-11-27
536 reads
Ladies and Gentlemen, welcome to the main event of the evening. The SQL Undercover Smackdown Heavy Weight Championship of the...
2017-11-16
2,527 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
317 reads
This months TSQL Tuesday subject is a shout out and high-five to those people who have inspired or made a contribution...
2017-11-14
708 reads
Hi Folks,
I’m the new guy that my two colleagues are still trying to convince to write my first blog post...
2017-11-14
468 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
399 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
199 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
1,216 reads
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
Referrals have never been more important in the job market. They’re no longer nice...
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Comments posted to this topic are about the item Make It Routine
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Comments posted to this topic are about the item Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers