(last updated: 2019-04-22 @ 13:00 EST / 2019-04-22 @ 17:00 UTC ) SQL Server 2012 introduced a significant improvement to CREATE CERTIFICATE: the ability to import a certificate —...
2019-05-03 (first published: 2019-04-22)
522 reads
One part of my job is to understand the compliance landscape. This means that I read a lot about the GDPR and related similar laws. I also have to...
2019-05-03 (first published: 2019-04-22)
489 reads
One of the most common questions I am asked about ETL configuration is how much memory SSIS requires. When configuring a new instance of SQL Server running SSIS, or...
2019-05-02
192 reads
Reading Time: 5 minutes (just do it!)
There is a lot of confusion when it comes to designing tables in SQL Server around whether to pluralize names or not. How...
2019-05-02
13 reads
Reading Time: 5 minutes (just do it!)
There is a lot of confusion when it comes to designing tables in SQL Server around whether to pluralize names or not. How...
2019-05-02
1 reads
Intro On July 9, 2019, support for SQL Server 2008 and 2008 R2 will end. That means the end of regular security updates. However, if you move those SQL...
2019-05-02 (first published: 2019-04-19)
1,025 reads
The vision for PowerShell Core is to be able to run PowerShell anywhere. In this article, I’m going to discuss how you can use Docker Containers to enable just...
2019-05-02
In my last post I showed how to build an Azure DevOps Pipeline for a Terraform build of an Azure SQLDB. This will take the terraform code and build...
2019-05-02 (first published: 2019-04-22)
445 reads
Since now, we will not keep our guests in secret. We want you to be prepared and wait if you’re interested in. First time 2 vs 2 in #AskSQLFamily...
2019-05-01 (first published: 2019-04-19)
197 reads
In today's world, people expect to be able to commit one change, then have the entire project re-deployed and automated tests run against it. Using the SSIS PowerShell...
2019-05-01
395 reads
Every Scooby-Doo mystery starts with a haunted house, a strange villain, and a trail...
By Steve Jones
Prompt AI released recently and I decided to try a few things with the...
By Kevin3NF
How should you respond when you get the dreaded Email/Slack/Text/DriveBy from someone yelling at...
Statistics Collection Interval: Defines the level of granularity for the collected runtime statistic, expressed...
I am using Microsoft SQL Server 2022 (RTM-CU17) (KB5048038) - 16.0.4175.1 (X64) Microsoft Corporation...
i have sqlexpress on rds, is there any way i can get notifacation that...
A table without a clustered index (heap) will NOT suffer from fragmentation during frequent updates or deletes. True or False?
See possible answers