While at PASS Summit 2019, I gave a session on designing Azure Disaster Recovery Strategies for the Data Platform. In that session, I talked about Azure storage and the...
2019-12-27 (first published: 2019-12-13)
268 reads
If you are like me, when certain events end, it is a bittersweet time. You’ve enjoyed your time with people you consider family, got to learn some new things...
2019-11-15 (first published: 2019-11-08)
419 reads
If you are at involved with the #sqlfamily, you are bound to hear about the benefits of social media platforms such as Twitter. Twitter helps us to engage each...
2019-10-31 (first published: 2019-10-18)
208 reads
In just a few days, I’ll begin my annual journey to Seattle, Washington for the PASS 2019 Summit. This is one of my favorite conferences to attend. It is...
2019-10-30
14 reads
Bench marking your environment is an important step when introducing new hardware, which is accomplished by running a test workload against the hardware. There are multiple ways to...
2019-10-03 (first published: 2019-09-27)
427 reads
Out of necessity are born the tools of laziness. This is a good thing. I have found that organizing and running a SQL Saturday event is a great way...
2019-09-23 (first published: 2019-09-13)
343 reads
In a previous post, I discussed the public preview of Azure SQL Database Serverless. This is a newer product released from Microsoft for the Azure ecosystem. Moving to this...
2019-09-13 (first published: 2019-08-30)
877 reads
When dealing with cloud technology there is a phrase that everybody should remember: Physics Always Wins. There isn’t any way to get around the speed of light (2.98 x...
2019-07-26
140 reads
Recently, I needed to be able to determine the total size for all the most recent full backups for certain servers. Luckily for me these particular servers were using...
2019-07-15 (first published: 2019-06-28)
417 reads
Let’s be honest here, data security is really important to me. Some people probably think that I go to extremes...
2019-04-03 (first published: 2019-03-15)
680 reads
Is EXISTS(SELECT 1 ...) better than EXISTS(SELECT * ...)? Who would know better than...
By Will Assaf
Working on a SQL 2017 database where an external, non-Microsoft application has direct access...
Last year Azure SQL Database Managed Instance saw the introduction of bring your own...
Comments posted to this topic are about the item Towards an efficient interface between...
How to handle date on temp table when is null or not ? I...
Thanks for fielding this question in advance: We are searching for a Microsoft SQL...
Ask SSC