The Value of Certifications
A former co-worker recently sent me an email asking about Microsoft certifications, and if I pursued them, and what I...
2013-02-05
1,095 reads
Blog Posts
Transactional Replication Toolbox Scripts: Show Articles And Columns For All Publications
During the last few years I've worked extensively with transactional replication and have written a handful of scripts that have...
2013-02-05 (first published: 2013-01-29)
2,757 reads
A Month of PowerShell – Day 4 (Scripting)
Welcome to Day 4 of my “A Month of PowerShell” series. This series will use the series landing page on...
2013-02-04
998 reads
Adding the Clustered Key To Your Nonclustered Index?
A colleague of mine was understandably confused when using the almost-perfect missing index engine in SQL 2008. The engine recommended he include...
2013-02-04
694 reads
Exploring Excel 2013 as Microsoft’s Business Intelligence Client
A little over six months ago, I wrote an article on Magenic.com about Excel 2013’s Impact for BI Users. This...
2013-02-04
1,409 reads
Frequently asked SQL Server Queries
Data to test:
CREATETABLE [dbo].[emp]( [emp_id]
[nchar](10)NULL, [emp_name]
[nchar](10)NULL, [salary]
[int] NULL)ON [PRIMARY] insert emp( emp_id,emp_name,salary ) select'1','ABC',-20000 insert emp( emp_id,emp_name,salary ) select'2','XYZ',-5000 insert emp( emp_id,emp_name,salary ) select'3','PQR',-7800 insert emp( emp_id,emp_name,salary...
2013-02-04
756 reads
How to Remove (Undo) Table Partitioning
I have seen plenty of articles and blog posts out there for how to setup and implement table partitioning, but...
2013-02-04 (first published: 2013-01-29)
8,783 reads
I hate Windows 8 and Microsoft Top 3 Mistakes
What do you think about Microsoft new Operating System? I hate Windows 8! This is the answer that many people...
2013-02-04
999 reads
Last Weeks Top 10 “Reading” Links #18
Throughout the week, I like to tweet links to the things that I’ve been reading. Since they all come out through out...
2013-02-04
494 reads
New DMO in Azure SQL Database: sys.dm_db_wait_stats
I just did a series of Boogle searches and when that didn’t find anything I tried Ging. Neither listed sys.dm_db_wait_stats....
2013-02-04
1,406 reads
Blogs
Microsoft Fabric OneLake Shortcuts: When to Use Them and When Not To
By James Serra
An architecture scenario Imagine separate Sales, Finance, Shared Data, and Executive Analytics workspaces. Sales...
SQL Server Security Hardening Guide Using the DoD STIG Checklist
Security on your SQL Server is important. That doesn’t need any explaining. But where...
EightKB 2026: Registration is Open!
It’s that time of year again! EightKB is back on August 20th at 13:00...
Forums
Alamat Kantor BCA KCU Kedoya Permai Tlp:08218154374
Hub Via Wa:628218154374 Alamat: Ruko Taman Kedoya Permai, Blok A 1A, No No.4-5, RT.11/RW.5,...
Alamat Kantor BCA KCU Gajah Mada Tlp:08218154374
Hub Via Wa:628218154374 Alamat: Jl. Gajah Mada No.112 B-C-D, RT.1/RW.1, Krukut, Kec. Taman Sari,...
Alamat Kantor BCA KCU Pluit Telp:08218154374
Hub Via Wa:628218154374 Alamat: Landmark Pluit, Jl. Pluit Selatan Raya Blok A8, RT.8/RW.10, Pluit,...
Question of the Day
Backing Up a DMK
In SQL Server 2025, I have a database with a Database Masker Key (DMK). I want to back up this key and keep a copy offline. When do I have to open this key before running the backup?
See possible answers