Data Warehousing Tip: Surrogate Key Generation
If IDENTITY insert is disabled or simply not available in a particular database or a database architecture, you’ll want to...
2013-04-12
940 reads
Blog Posts
DBA Question of The Day: What is SAVE TRANSACTION?
Hello Dear Reader! I was teaching a class in Chicago last week and I got a lot of really great...
2013-04-12
1,136 reads
Introduction to SQL Server 2012 – Webcast Resources
First, I would like to thank everyone for joining my webcasts today. Very much appreciated. Secondly, I would like to...
2013-04-12
1,040 reads
Parsing Glenn Berry’s Diagnostic Information Queries With PowerShell
Do It In Bulk
I usually don’t run queries on just one server. Most of the time I need to get...
2013-04-12
1,267 reads
PASS Business Analytics Conference Live Blog
Apologies if you went to my site this morning to see my blog from the bloggers table at PASS Business Analytics...
2013-04-12
741 reads
Reblog: April 5 to April 11
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-04-12
405 reads
SQL Saturday#197–Omaha Recap
This was the second SQL Saturday hosted in Omaha. I loved to see how the event grew from the first...
2013-04-12
480 reads
SQL Server – Add Date/Time to output file of BCP / SQLCMD (2)
Last time I posted about How you can add date/time to output file name, in which I used xp_cmdshell to...
2013-04-12
2,367 reads
UNPIVOT a table using CROSS APPLY
I generally spend part of each day looking through http://www.stackoverflow.com, http://dba.stackexchange.com or http://www.sqlservercentral.com. I read through questions that have already...
2013-04-12 (first published: 2013-04-01)
4,191 reads
Entertainment for the Traveling Consultant (UltraViolet Review)
Like many of us, I have a collection of favorite movies. These include Ghostbusters, Stripes, Serenity, and dozens more. I...
2013-04-11
776 reads
Blogs
Measuring RAG Solutions: Are We Retrieving the Right Information?
A RAG pipeline that answers questions in the demo is not the same thing...
Advice I Like: Lots of Ideas
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Building a DBA Agent for Your SQL Server Estate with MCP
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Forums
BCA KCU MENARA BIDAKARA Telp:0821-8200-203
Telp/WA 62 821-8200-203 Menara Bidakara, Jl. Gatot Subroto No.Kav.71-73 Lt. Lobby dan Lt. 1,...
BCA KCU KEBAYORAN BARU Telp:0821-8200-233
Telp/WA 62 821-8200-233 Jl. Melawai Raya No.Blok B, RT.7/RW.5, Kramat Pela, Kec. Kby. Baru,...
BCA KCU PONDOK INDAH Telp:0821-8200-174
Telp/WA 62 821-8200-174 Wisma BCA Pd. Indah, Jl. Metro Pondok Indah No.10, RT.3/RW.17, Pd....
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers