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.
Configuring Critical SQL Server Alerts
What do you do when you want to receive critical server health alerts?
Double Up During Trips
When you develop software, it pays to write efficient code. However it doesn't seem that many companies truly believe this as they aren't always investing in their staff.
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.
Data Mining Part 20: Excel and Data Mining,accuracy, forecasting
In the lesson 18 and 19 we worked with Data Mining Models.
In this new chapter we will work with more algorithms and show how to test the accuracy of the model.
Data Mining Part 20: Excel and Data Mining,accuracy, forecasting
In the lesson 18 and 19 we worked with Data Mining Models.
In this new chapter we will work with more algorithms and show how to test the accuracy of the model.
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.
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".
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.
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
Kontak Bank BCA KCP Purwosari [083178278662]
Alamat BCA KCP Purwosari WHATSAPP:083178278662 Solo Center Point, Ruko No. A11 & A12, Sondakan,...
Alamat Bank BCA KCP Palur [083178278662]
WHATSAPP:083178278662 Jl. Raya Palur No.Km 5, Jurug, Ngringo, Kec. Jaten, Kabupaten Karanganyar, Jawa Tengah...
Question of the Day
ORDER BY alias
There is a table tmp_tab:
CREATE TABLE tmp_tab ( id int, val int );
INSERT INTO tmp_tab VALUES (1, 1), (2, NULL), (3, 3), (4, 4), (5, 5);You want to order the rows ids by the following expression:
ISNULL(val, id) + 1Which of the following queries produces the expected ordering and why? (Select all correct) See possible answers