New Year Aspirations – boB Taylor – MCM
Thanks for agreeing to do this boB. It’s great to be able to interview the Microsoft program manager for the...
2013-01-22
1,895 reads
Blog Posts
Pro SQL Server 2012 Practices Chapter 18 Review Tuning for Peak Load
I'm on a Book!
Hello Dear Reader, early last year I was asked if I would like to contribute to a...
2013-01-22
911 reads
Script to Populate Date Dimension, without Using a Cursor
Most of the scripts I’ve used to populate date dimension uses a cursor. Since data is loaded only once to...
2013-01-22
828 reads
Script to Populate Date Dimension, without Using a Cursor
Most of the scripts I've used to populate date dimension uses a cursor. Since data is loaded only once to...
2013-01-22
2,491 reads
sp_PerformanceCounters - Get a Health Check of SQL Server's Performance
During your career as a DBA, you'll run across articles by SQL experts or other DBAs that just give you...
2013-01-22
1,363 reads
SQL Server 2012 for Beginners
I have been working for Microsoft for the past two years. One of the most enjoyable parts of my job...
2013-01-22
986 reads
SQL Server Backup and Recovery Fundamentals Presentation
SQL Server Backup and Recovery Fundamentals – February 5th, 2013 A copy of the recording is available here. Code and slides...
2013-01-22
771 reads
SQL Server Views
This post is first of yet to come long series on basic concepts of SQL Server. I’ll begin with basic...
2013-01-22
803 reads
Few thoughts
I would like to share few thoughts/updates with our SQL Server community.
1. While checking my SSC blog posts, i realised that my...
2013-01-21
1,340 reads
Important Update for SQL Server 2012 SP1
One of the challenges we faced this week was a high CPU usage on one of our SSAS Cluster boxes when there was very little activity, plus some errors...
2013-01-21
12 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
Alamat BCA KCP Pasar Minggu Telp:0821-8200-233
Telp/WA 62 821-8200-233 Jl. Raya Pasar Minggu No.6, RT.6/RW.8, Kalibata, Kec. Pancoran, Kota Jakarta...
Alamat BCA KCP Pejaten Telp:0821-8200-203
Telp/WA 62 821-8200-203 Ruko, Jl. Pejaten Mas Raya Jl. Raya Pasar Minggu No.Km.20 No....
Alamat BCA KCP Tebet Timur Telp:0821-8200-174
Telp/WA 62 821-8200-174 Jl. Tebet Timur Dalam Raya Blok GG No. 97, RT.3/RW.6, Tebet...
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers