MidnightDBA at SQL Saturday Houston – May 10
Sean and I will be speaking at SQL Saturday Houston on May 10, at San Jacinto College – South Campus 13735...
2014-04-14
651 reads
Collation: Correction -> Instance
I had a recent run in with collation problems and it got me started reading about them. As I read...
2014-04-14
468 reads
Collation: Correction -> Instance
I had a recent run in with collation problems and it got me started reading about them. As I read...
2014-04-14
674 reads
SQL Server – Different Ways to Check Object Definition
sp_helptext is widely used for checking object definition in SQL Server. sp_helptext can be used to check definition of various...
2014-04-14
150 reads
SQL Server – Different Ways to Check Object Definition
sp_helptext is widely used for checking object definition in SQL Server. sp_helptext can be used to check definition of various...
2014-04-14
312 reads
SQL Server – Different Ways to Check Object Definition
sp_helptext is widely used for checking object definition in SQL Server. sp_helptext can be used to check definition of various...
2014-04-14
1,102 reads
5 Years Running! OKCSQL!
I want to congratulate OKCSQL on a 5 year run.
I personally wasn't here for that whole duration, but we have leaders and...
2014-04-14
703 reads
Missing Database Owner
By David Postlethwaite
At my presentation on SQL Server Management Studio at SQL Saturday in Exeter I promised to write some...
2014-04-14
2,833 reads
Hortonworks Data Platform 2.1 New Features
What is Hortonworks Data Platform
Hortonworks recently announced their release of the HDP 2.1 their Hadoop Big Data platform. If you...
2014-04-13
915 reads
Using the T-SQL MERGE Statement
In SQL Server 2008, Microsoft added a new SQL query type: the MERGE statement. This flexible query provides the ability...
2014-04-13
5,720 reads
Blogs
The New Unified Copilot in Fabric and Project Osmos: From AI Assistance to Agentic Data Engineering
By James Serra
(This post starts a three-part series on how AI is changing the way we...
SQL Server Problems You Can Reproduce, Measure and Fix: A Free Demo Library
I built a free library of runnable SQL Server demos. Each reproduces a real...
Experimenting with CHOOSE: #SQLNewBlogger
By Steve Jones
I was looking over the CHOOSE() function while editing an article at SQL Server...
Forums
Alamat BCA KCP AEON Mall BSD Telp:0821°8200°203
Telp/Wa 628218200203 AEON Mall BSD City Ground Floor Unit G-80, 81 & 81A, Jl....
Alamat BCA KCP Raya Serpong Telp:0821°7555°651
Telp/Wa 628217555651 Jalan Raya Serpong 06, RT 008 RW 02, Pondok Jagung, Serpong Utara,...
Managed Instance vs Azure Database - is this a good option?
We're currently in Azure, however as we had a very tight migration timeline when...
Question of the Day
SQL Server 2025 Server-level Roles
In SQL Server 2022+, what does the ##MS_DatabaseConnector## role allow?
See possible answers