Friday SQL Nugget #1
Gee thanks Jes (blog|twitter). Just what I wanted, a little extra work on a Friday afternoon. I used to like...
2012-01-13
1,443 reads
Blog Posts
HP DL980…now this is a server!
I have been fortunate the past few months to be working on a HP ProLiant DL980 G7 Server. This is...
2012-01-13
957 reads
Moving Database Files and Replication
Today’s post is a quick one as I am a bit under the cosh.
There are many ways to move database...
2012-01-13
694 reads
Re-blog – January 6 – January 12
Welcome to the Friday Re-Blog summary post. The aim of these posts is to bring some old posts that newer readers may...
2012-01-13
652 reads
Bloopers from Dec 2012
The raw ones from podcasts in late Nov and Dec 2011.
Dec 2011 Bloopers
Filed under: Blog Tagged: Humor, syndicated
2012-01-12
1,124 reads
Database Mirroring From SQL Server 2005 to SQL Server 2008 R2 SP1 CU3
I recently ran into a production instance of SQL Server 2005 SP2 (Build 3042) that is running in a two...
2012-01-12
2,673 reads
DBAs@Midnight 6 week roundup
We’ve been awfully busy these last few weeks, what with holidays and work and whatnot. But that hasn’t stopped us...
2012-01-12
693 reads
Fragmented Index – Rebuild or Reorganize ?
Introduction
In past, many times I have written on Fragmentation of Indexes and how to Defrag them. You can find some...
2012-01-12
15,604 reads
Missing Indexes
SQL Server has means built into it to track possible missing indexes. This used to be found through the use of the Index Tuning Wizard. The process has improved...
2012-01-12
8 reads
Scaling SQL Server Presentation from SQLSaturday #104 Precon
On Friday, January 6, 2012, I got the opportunity to present an expanded version of my “Scaling SQL Server” presentation...
2012-01-12
1,177 reads
Blogs
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
I’m excited to announce the release of a new open-source project that fully automates...
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
Forums
Alamat Kantor BCA KCP Talavera Telp/Wa:0821-8200-233
CSO 08218200233 Talavera Office Park, Jl. TB Simatupang No.Kav. 26, RT.1/RW.1, Cilandak Bar., Kec....
Alamat BCA KCP Mega Kuningan Telp/Wa:0821-8200-203
CSO 08218200203 Lingkar Mega Kuningan No.Blok E 4, RT.5/RW.2, Kuningan, Kuningan Tim., Kecamatan Setiabudi,...
Alamat BCA KCP Wisma Mulia Telp/Wa:0821-8200-174
CSO 08218200174 Jl. Gatot Subroto No.42 Suite G02, RT.3/RW.2, Kuningan Bar., Kec. Mampang Prpt.,...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers