Containers: Getting an Image
I’m working with Docker running on Windows or Linux. There are other ways to do this, but Docker seems to be a pretty strong standard. I’ll leave it to...
2019-05-21
28 reads
Blog Posts
Exporting an .ISPAC from the SSIS Catalog via the SSIS PowerShell Provider
In my last blog post I showed that using the SSIS Provider could be an easier option for deploying an .ISPAC file, vs. the PowerShell script method shown in...
2019-05-21 (first published: 2019-05-06)
853 reads
Happy Hour at SQL in the City Austin
Tomorrow is SQL in the City 2019 – Austin. If you’ve registered, you’re going to want to come. From Kendra’s great opening keynote to Brian’s demo to a couple...
2019-05-21
13 reads
Keynotes in Australia and New Zealand
I get to do the SQL in the City Summit keynotes in Australia and New Zealand. I’m excited, following the footsteps of Kendra Little and Donovan Brown, who have...
2019-05-21
18 reads
Microsoft SQL Server Error 5243 – Top 3 Ways To Fix This Issue
Maintaining the SQL server database is always the first priority of the SQL administrators. But sometimes SQL database users have to face Microsoft SQL server error 5243 and error...
2019-05-21
19 reads
Microsoft SQL Server Error 5243 – Top 3 Ways To Fix This Issue
Maintaining the SQL server database is always the first priority of the SQL administrators. But sometimes SQL database users have to face Microsoft SQL server error 5243 and error...
2019-05-21
225 reads
Predicate Execution Order on Mixed Data Type Columns
Watch this week's video on YouTube
SQL Server's cost-based query optimizer does a pretty good job of figuring out what order to filter your data to get fast query executions....
2019-05-21
5 reads
Predicate Execution Order on Mixed Data Type Columns
Watch this week's video on YouTube
SQL Server's cost-based query optimizer does a pretty good job of figuring out what order to filter your data to get fast query executions....
2019-05-21
9 reads
Strategies for Compliant Development Down Under
I’m doing a tour of Australia and New Zealand with our SQL in the City crew. We’re going to be in Brisbane, Christchurch, and Melbourne on three consecutive weeks....
2019-05-21
3 reads
T-SQL Tuesday #114 Puzzle Party – Roundup
Here’s my round-up for this month’s T-SQL Tuesday. Thanks to everyone who contributed last week. It was great reading your posts and seeing the different ways you interpreted the...
2019-05-21
99 reads
Blogs
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
A Las Vegas Break
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
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...
Migrate SSRS Reports to PowerBI Report Server in SQL Server 2025
Comments posted to this topic are about the item Migrate SSRS Reports to PowerBI...
Identities and Sequences III
Comments posted to this topic are about the item Identities and Sequences III
Question of the Day
Identities and Sequences III
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which can be used with the BIGINT data type?
See possible answers