It’s 2016. So why are we still dealing with T-SQL code and design patterns that were designed 7 versions ago?
In the 15 years I have been using databases professionally, we’re still...
2016-10-11
2 reads
Something in SQL Server that isn’t always obvious to beginners is that when you create a default value for a column on a table, SQL Server creates a constraint...
2016-01-19
6 reads
This week’s #sqlnewblogger posts!
Author Post @eleightondick [[T-SQL Tuesday] Data modeling: The trouble with prefixes @tomsql Adventures With TomSQL, aka Tom Staab @EdDebug [Automatically name primary key constraints in SSDT...
2015-11-19
5 reads
I have a situation where I need to retrieve the data in an encrypted column from, but don’t want to give all my users access to the symmetric key...
2015-11-18
3 reads
This week’s #sqlnewblogger posts!
Author Post @arrowdrive Anders On SQL: T-SQL Tuesday #72: Data modelling gone extremely wrong @rabryst Time After Time - An Introduction to Temporal Tables in SQL...
2015-11-12
2 reads
If you need to move data from one table into a new table, or even tables in a database into another database, the Import/Export Wizard in SQL Server Management...
2015-11-11
4 reads
Ed Leighton-Dick has renewed his New Blogger Challenge this month. Here are all (I think) the posts for this week after Ed posted his announcement. If I’ve missed any, please let...
2015-11-05
1 reads
Spend any time around a 4 year old, and you will inevitably find yourself involved in a conversation which evolves into this:
Please do this thing Why? Reasonable answer Why? Restatement...
2015-11-04
4 reads
So you’ve decided that your new web application needs to record some page load time metrics so you can keep tabs on performance. Terrific! You set up a couple page load/complete...
2015-06-16
4 reads
Consider this the outtakes from my previous post about speaking at SQL Saturday.
It took a while for me to build up the courage to finally get up in the...
2015-06-02
5 reads
By Brian Kelley
Even preparing for a class or seminar with set materials takes a lot of...
By DataOnWheels
I can’t believe it’s finally here! A way to have Excel live in OneDrive...
By Steve Jones
This image is from 2010, and it goes along with my last post of...
All week we've had issues with the site being up and down. There's been...
I created a post (or tried) in the 2022 Admin forum. https://www.sqlservercentral.com/?post_type=topic&p=4694880 But it's...
In which versions can I mirror a database from an on-premises SQL Server to a Fabric data warehouse?
See possible answers