Copying SSIS packages With DTUTIL
A frequent need when performing a server migration is to copy the SSIS packages from one server to a new...
2016-02-15 (first published: 2016-02-05)
6,484 reads
Blog Posts
Did you know?
Did you know that the call for speakers for PASS Summit 2016 opened on February 3, 2016?
Did you know that...
2016-02-15
447 reads
Importing Open Data Sets in SQL Server
Whilst working on an upcoming post I realised that I needed a decent data set on which to test some...
2016-02-15
718 reads
Loading Data into Azure SQL Data Warehouse
Ouch.
Let’s start with the level set. I’m not an ETL expert. In fact, I haven’t done any professional ETL work...
2016-02-15
1,541 reads
Monday Morning SQL Break – February 15, 2016
It’s Monday time for this week’s weekly blog and twitter round-up for last week. If you haven’t already, follow me...
2016-02-15
398 reads
Quick Tests–Function Returns
I ran across a neat piece of code recently from Gail Shaw. She answered a question on returning the base...
2016-02-15
1,454 reads
Shrinking Database Log Files
When should you shrink your log files and what does it mean to performance?
2016-02-15
125 reads
Shrinking Database Log Files
Files in SQL Server need to grow as the database grows, and in very specific circumstances need to be shrunk...
2016-02-15
1,288 reads
Speaking at the first Belgian SQLSaturday!
I’m delighted to announce that I’ll be giving a session at the very first SQLSaturday (aka SQLSaturday 505) in Belgium....
2016-02-15
499 reads
SQL Server 2016 Row-level Security and SSRS a perfect match
In this blog I will explain and demonstrate how to leverage a new feature in SQL Server 2016, Row Level...
2016-02-15 (first published: 2016-02-08)
9,087 reads
Blogs
Learning Tool – Deepstash
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Cleaning Up My Blog's SEO and AEO with Claude in GitHub Copilot
I’ve been running this blog on Hugo for a long time, and like most...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers