TSQLTuesday.com
I’ve hosted a page on this blog that has all the T-SQL Tuesday blog invitations and roundups linked. I did...
2017-03-10 (first published: 2017-02-28)
2,011 reads
Blog Posts
Determining the Cost Threshold for Parallelism
In the previous post, I showed how you can get full listings of your execution plan costs. Knowing what the...
2017-03-09 (first published: 2017-02-28)
1,951 reads
Metadata Hygiene
Those who follow my blog know that I write a lot about data quality. Measuring and improving the quality of...
2017-03-09
417 reads
Power BI and Excel options for Hadoop
Below I have attempted to list the various options for reporting off of Hadoop (HDInsight, HDP, Cloudera) using Power BI...
2017-03-09
571 reads
SQL Browser, what is it good for? Absolutely something!
Another great teaching opportunity landed in my lap this week. I got an email from a coworker looking for some...
2017-03-09 (first published: 2017-03-01)
3,413 reads
Working with SQLSaturday SpeedPASSes
SQLSaturday SpeedPASSes
I’ve been working with running SQLSaturdays in the Richmond, VA area for several years now. It seems that every...
2017-03-09
449 reads
Configuring and analyzing the Query Store through dbatools
In case you didn’t know this already, dbatools is an awesome collection of Powershell functions that will help you immensely...
2017-03-08 (first published: 2017-02-27)
2,399 reads
Create a DACPAC to Move Databases–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-03-08
945 reads
Exporting Container Images
I’ve already covered how to push images to the Docker hub here but what if we only want to share...
2017-03-08
404 reads
Identifying a row’s physical location
While you may not need to worry about the physical location of a row very often, every so often the...
2017-03-08
501 reads
Blogs
Case Studies: Real-World Success Stories of FinOps Implementation
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
SQL Server Security: Always Encryption
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Identity Defaults
Comments posted to this topic are about the item Identity Defaults
Question of the Day
Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers