The Migration Checklist
Today Steve Jones talks about the checklist you would want if you needed to move a SQL Server instance to new hardware.
Move Azure SQL Databases using the Export and Import PowerShell cmdlets
John Miner shows how to move databases between a cloud development environment and an on-premise production environment using PowerShell cmdlets.
Detective Stories - Tracking Down the Database's Dependents Part 2
No worries about dropping databases. Now we can search for its dependencies before the database dies. Part 2 of a 2-part article.
Query Store and In-Memory OLTP
Once you have Query Store enabled on your databases, runtime statistics are generated for your queries; but what about the natively-compiled stored procedures and memory optimised tables that come with In-Memory OLTP? Do you get the full range of runtime statistics? This is an intriguing question that Enrico explores and answers.
SSIS Catalog Compare v2.0 Launch Event
Join the SSIS Catalog Compare v2.0 Launch Event on Tue, Mar 7 at 13:00 EST.
Containing the Work
Containers are valuable in many software domains. Are there places we, as data professionals, would like to use software containment?
Creative IT Learning
If a successful IT career is just as much about tenacity, interest and retention as it is about brainpower, then how does one go about continuous learning?
Detective Stories - Tracking Down the Database's Dependents Part I
No worries about dropping databases. Now we can search for its dependencies before the database dies. Part 1 of a 2-part article.
Project Bletchley - The Microsoft Vision for Blockchain
The SQL Server Luxembourg User Group invites you to join us at our next event in Microsoft’s Offices, at 6:00pm on Tuesday 7th March
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Liability for AI Errors
Comments posted to this topic are about the item Liability for AI Errors
Running a Parameter-Sensitive Stored Procedure on a Secondary Replica
Hello , I would like to run a stored procedure on a secondary replica...
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers