T-SQL Tuesday #104 Roundup
This month's T-SQL Tuesday topic asked "What code would you hate to live without?" Turns out you like using script and code to automate boring, repetitive, and error-prone tasks.
Thank...
2018-07-17
12 reads
SQL Server Audit Recipe – xp_cmdshell
This article assumes you already have a basic understanding of SQL Server Audit, but if not, use this link to catch...
2018-07-17
213 reads
SQLSaturday Baton Rouge at LSU on August 11
We're a little under a month away from #SQLSatBR!We need VOLUNTEERS.Registration is required!We still have tables of all sizes available for sponsors!Our 10th annual SQLSaturday features an 14-track lineup...
2018-07-17
18 reads
Quickly Change SQL Job Owners
It is not unusual to find a server where some random user created a bunch of jobs to be run by SQL Agent. Sometimes, the user creating the job(s)...
2018-07-16
22 reads
Quickly Change SQL Job Owners
It is not unusual to find a server where some random user created a bunch of jobs to be run...
2018-07-26 (first published: 2018-07-16)
2,497 reads
Understanding Data Sharing in SQL Server Docker Containers
This article talks about shared volumes and the preferred mechanism for data persistence using the Docker containers. This article covers...
2018-07-16
569 reads
Solving Ken’s FizzBuzz 3D–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2018-08-03 (first published: 2018-07-16)
1,915 reads
Databases and DevOps, Tools are the Easy Part
Moving your database development, deployment and management into a DevOps methodology does involve choosing and implementing tools and tooling. Tools...
2018-07-25 (first published: 2018-07-16)
2,074 reads
SQL Saturday Louisville–Bout That Time
SQL Saturday Louisville is less than a week away!! A lot of hard work has gone into putting on this...
2018-07-16
179 reads
Counting NULLs
Recently I was doing one of Kendra Little’s (b/t) SQL Server quizzes. Specifically the Quiz: COUNT() in SQL Server. As...
2018-07-16
1,106 reads
Blogs
Paginated Reporting at Scale: Choosing the Right Microsoft Platform
By Rayis Imayev
"I've seen things you people wouldn't believe..."— Roy Batty, Nexus-6 Replicant, Blade Runner (1982)(2026-Nov-08) Yep,...
The Book of Redgate: Fun with Images
By Steve Jones
We’ve celebrated our birthday many times at Redgate. In the Book of Redgate –...
Why companies use Palantir and how we help implement it in the Czech Republic
Discover how Palantir connects enterprise data, supports AI-driven decision-making and helps companies turn insights...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Too Many Choices
Comments posted to this topic are about the item Too Many Choices
Table Partitioning in SQL Server: A Practical Guide to Managing Very Large Tables (VLDBs)
Comments posted to this topic are about the item Table Partitioning in SQL Server:...
Question of the Day
Too Many Choices
I have a table, dbo.MasterBrands, with this data:
BrandID OfficialName 1 Samsung 2 Apple 3 Microsoft 4 Adidas 5 Coca-ColaI run this query. What is returned for Coca-Cola?
SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel') FROM dbo.MasterBrands;See possible answers