SQL Server Index Tuning for Mere Mortals
One of the most important things to measure, monitor, and “get right” for good overall SQL Server OLTP performance is...
2011-01-11
2,969 reads
Articles
Transparent Database Encryption in SQL Server: A Planning Guide
A planning guide for the implementation of TDE in SQL Server.
2011-01-10
7,359 reads
TSQL Challenge 47 - Read the modification history and identify the fir
A table contains the list of modifications made to each card. Your job is to write a query that shows the first number, current number (most recent) and the number of changes made.
2011-01-10
960 reads
Natural vs. Surrogate Keys in SQL Server : Getting the Proper Perspective
This article demonstrates the relative merits of natural and surrogate keys and benchmarks their performance in different scenarios.
2011-01-10
4,502 reads
Profiling Database Activity in the Entity Framework
It’s important to profile your database queries to see what happens in response to Entity Framework queries and other data access activities, says Julie Lerman, who gives you the details on several profiling options to improve you coding.
2011-01-07
3,027 reads
Raffle SQL Server Style
This article presents a possible solution to the raffle logistics employed in SQL Server user group meetings around the world.
2011-01-06
3,778 reads
Beginning Powershell Companion PDF
Howdy all…as is so often the case, I’m studying something – Powershell – and I’m in need of a reference to help...
2011-01-06
3,404 reads
Script Task and Event Logging in SSIS
components. These same configuration settings can be leveraged in Script Task, but you also have the option of triggering and tracking events in a considerably more customizable manner. This article explores features that provide this flexibility.
2011-01-06
3,819 reads
Tackle the Question of the Day on your cell phone
SQLServerCentral has a mobile site to enable you to access the question of the day from your cell phone.
2011-01-05
991 reads
31 Days of SSIS – Raw Files Are Awesome (1/31)
As I mentioned in the introductory post, I’m writing 31 Days of SSIS. Let’s start off this series with a...
2011-01-05
3,133 reads
Blogs
Programmatic Tool Calling with the Claude SDK
Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...
A New Word: Mauerbauertraurigkeit
By Steve Jones
mauerbauertraurigkeit – n. inexplicable urge to push people away, even close friends whose company...
Methodology for dealing with bad data in production
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
Forums
KONTAK BCA KCU SIDOARJO Telp:(08218154392)
Alamat Kontak WA CS 08218154392 Jl. Ahmad Yani No.39 A, Rw1, Sidokumpul, Kec. Sidoarjo,...
KONTAK BCA KCU RUNGKUT Telp:(08218154392)
Alamat Kontak WA CS 08218154392 Jl. Raya Kendangsari Industri No.2, Kendangsari, Kec. Tenggilis Mejoyo,...
Question of the Day
BIT_COUNT() IV
In SQL Server 2025, I run this code:
select bit_count('A')
What is returned? See possible answers