Dem queries
Dem queries, dem queries, dem slow queries,
Dem queries, dem queries, dem fast queries,
Dem queries, dem queries, dem big queries,
Now write...
2019-02-27
1,153 reads
Editorial – Dealing with Ugly Babies
One thing I learned while working as a database administrator over 17 years is the importance of teamwork across departments....
2019-02-27
249 reads
A short guide to sp_executesql
Last week I talked about single use plans. One way to increase execution plan re-use is to parameterize queries by...
2019-02-27
2,442 reads
Using Github as a repository for SQL Server Helm Charts
In a previous post I ran through how to create a custom SQL Server Helm chart.
Now that the chart has...
2019-02-27
424 reads
What Does the Undocumented UNCOMPRESS Function Do?
(last updated: 2019-02-26 @ 18:35 EST / 2019-02-26 @ 23:35 UTC )
IntelliSense in SQL Server Management Studio (SSMS) can be quite helpful. It...
2019-02-26
1,039 reads
Checking Progress of the Creation of your Azure Resources
When I’ve created resources in Azure it’s usually taken from a few minutes and up to quarter of an hour...
2019-02-26
847 reads
Workload analysis with WorkloadTools
Last week I introduced WorkloadTools and promised additional posts to describe what it can do in more detail. So, here...
2019-02-26
588 reads
The Reader’s Choice Awards are Taking Nominations
If you’re using products, you might want to nominate a vendor or product for a database tool that helps you....
2019-02-26
889 reads
Undercover TV – Sean McCown Joins Us For a Session on Beginning Powershell SMO
In this episode, Adrian looks at some of the new features of the Undercover Inspector1.3 and special guest, Sean McCown...
2019-02-26
245 reads
Cool Stuff in Snowflake – Part 7: Creating Tables
I’m doing a little series on some of the nice features/capabilities in Snowflake (the cloud data warehouse). In each part, I’ll highlight something that I think it’s interesting enough...
2019-02-26
99 reads
Blogs
Creating a Local Model Chatbot on Windows
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
To refer and to be referred
Referrals have never been more important in the job market. They’re no longer nice...
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Forums
Querying Multiple Tables for the Same Information
I have about 100 Tables that are all suffixed with _Modify. These tables record...
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Question of the Day
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