Overcoming the OPENQUERY Record Limit for AD
Sometimes you have to pull more than 50,000 records. A script to do that inside the 1000 record limit.
2014-11-13
8,131 reads
Articles
Configuring Critical SQL Server Alerts
What do you do when you want to receive critical server health alerts?
2014-11-13
8,936 reads
Database Configuration Management for SQL Server
It is not just the rapid and painless testing, deployment and update of databases that requires care in the retention and management of configuration information. Configuration information is also essential for audit, resilience, and support. The range of documentation varies widely with the database and its setting, but the underlying principles remain the same. Without appropriate configuration management, automation is likely to be futile.
2014-11-12
10,784 reads
SQL Server Source Control Basics
Source control can and should play a key role in the database development and deployment process, and this book will show you exactly how to get started.
2014-11-11
1,917 reads
Troubleshooting SQL Server: A Guide for the Accidental DBA
Three SQL Server MVPs, and stalwarts of the SQLServerCentral and MSDN community forums, provide fascinating insight into the most common SQL Server problems, why they occur, and how they can be diagnosed using tools such as Performance Monitor, Dynamic Management Views and server-side tracing. The focus is on practical solutions for removing root causes of these problems, rather than "papering over the cracks".
2014-11-11
25,935 reads
Set up a Memory Quota for SQL Server Memory Optimized Databases
You successfully entered into the In-Memory OLTP world by the hand of SQL Server 2014. After a while you notice that the In-Memory objects are using more memory than you estimated. In this tip you will learn how to proceed.
2014-11-11
7,759 reads
SQL Server Luxembourg: Wait Watchers
On November 19, 2014, the SQL Server Luxembourg User Group and Dell Software will be hosting a free event. Richard Douglas will be be presenting a double bill: SQL Server 2014 features everyone can use, and Wait watchers - Gain Performance Increases Fast! This event is free to registered attendees.
2014-11-11
6,908 reads
Using Comments to Quickly Test CTEs
A quick tip for using a combination of block and line comments to test CTEs
2014-11-10
7,450 reads
Acceptance Testing with FitNesse: Database Fixtures, Project Overview
There aren't many frameworks for writing acceptance tests for databases, including SQL Server. FitNesse is an obvious choice since it is designed with a Wiki-style interface that, once it is configured and set up correctly, makes it very easy for a non-specialist to set up individual tests.
2014-11-10
5,527 reads
ETL Performance Auditing - Part 2: Auditing Data Staging Phase
Easy way to setup a comprehensive ETL Performance auditing Solution no matter how complicated your ETL setup.
2014-11-07 (first published: 2012-06-12)
10,183 reads
Blogs
VPN + SQL Server Connections: Why Long-Working Setups Suddenly Fail with Msg 10054 and “Connection Broken”
By Tim Radney
Over the past few weeks, I’ve been contacted by multiple customers experiencing the same...
Future IT Roles – Agentic Architect and AI Boom!!
By Vinay Thakur
These days everything is changing to AI World, IT roles are getting changed and...
Free Webinar about Columnstore Indexes
I’m doing a small series on indexing basics for SQL Server, and on May...
Forums
BCA KCU BINTARO Hubungi Cs.0851•8812•0691
BCA KCU BINTARO Hubungi Cs.0851•8812•0691 Bintaro Jaya Blok A-5 No.12 & 15, Sektor 7,...
BCA KCP Bojong Indah Tlpn/wa0853.7373-7551
Komp. Bojong Indah Cengkareng, Jl. Pakis Raya 88 H, Daerah Khusus Ibukota Jakarta 11740
BCA KCP Lodan Center TLP/WA 08216366654
LODAN CENTER, Ruko Jl No.6-7 Blok O, Ancol, Kec. Pademangan, Jkt Utara, Daerah Khusus...
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers