2020-07-25
265 reads
Database Weekly
Digging Into Internals
There are plenty of experts that look to teach you about query tuning and the internals of query execution in SQL Server.
2020-07-18
144 reads
Controlling Intelligent Query Processing Features
I always look forward to new T-SQL features and optimizer enhancements with every new version of SQL Server. Starting in 2017, Microsoft came up with a set of features called Intelligent Query Processing (IQP). These features work to improve performance without changing any code. If you’d like to learn more about these features, take a […]
2020-07-11
140 reads
2020-06-20
69 reads
What is Azure SQL Database Serverless?
I remember when the first SQL databases were available on Azure. The size limits and missing features made them impractical for most uses at the time. Fast forward 10 years and you can you create a terabyte database and take advantage of configurations like Hyperscale, Elastic Pool, and Managed Instances. You get automatic high-availability and […]
2020-06-13
153 reads
The Social Impact of Data
Let the data drive your decisions. This has been something of a mantra for many technical people, and even many business people, across the last twenty or so years. The allure of business intelligence is harnessing lots of data to make decisions that are rooted in some rational analysis of what has happened. Many companies […]
2020-06-06
42 reads
The Build Book of News
Every year Microsoft has held the Build conference for developers. I've been lucky enough to go a few times, and I was hoping to get the chance to attend again. With the pandemic, the entire event went virtual, and was held across 48 continuous hours. I was slightly disappointed as a few sessions I wanted […]
2020-05-23
67 reads
Bad Managers
I’m constantly hearing stories about terrible managers, and, of course, I’ve experienced quite a few myself. In fact, I can’t come up with many nice things to say about most managers when I look back over my career. (Luckily, my manager at Redgate is wonderful!) Early in my tech career, I was working at a […]
2020-05-16
172 reads
2020-05-09
112 reads
2020-04-25
105 reads
Blogs
Would You Pass the SQL Server Certifications Please? What Do You Mean We're Out?
I have held various certifications through my DBA career, from CompTIA A+ certification back...
PASS Summit 2020 Mental Health Presentation Eval Comments
I first starting presenting on mental health last December in Charlotte, NC on mental...
PASS Summit 2020 Mental Health Presentation Eval Comments
I first starting presenting on mental health last December in Charlotte, NC on mental...
Forums
Ideas for Auditing
I'm currently looking to design some auditing on my SQL application and am wondering...
Set Variable to lookup first row value with white space in property name
Hi, How can I set the value of a variable from a Lookup activity...
How to aggregate Dimension values properly
Ahoi, im trying to deal with a user request to combine 2 values of...
Ask SSC