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
Where Is My SQL Agent? Running Scheduled Jobs Against Azure SQL Database
By gbargsley
One of the first things I review when I inherit a new SQL Server...
AgentDBA vs Critical SQL Server
By Arun Sirpal
It’s 07:43. Someone’s already left a message. “Something’s wrong with the DB server.” You...
Finally Cleaning Up Dropbox: Moving Almost a TB to Google Drive with rclone
By davebem
I’ve had a Dropbox account for years. Like a lot of people, I started...
Forums
identity increments by 10,000 when it was supposed to be 1
hi a peer of mine who ive never known to be wrong says a...
Displaying Money
Comments posted to this topic are about the item Displaying Money
The Slow Growing Problems
Comments posted to this topic are about the item The Slow Growing Problems
Question of the Day
Displaying Money
I want to get the currency sign displayed with my amount stored in a money type. Does this work?
DECLARE @Amount MONEY; SET @Amount = '?1500'; SELECT CAST( @Amount AS VARCHAR(30)) AS EurosSee possible answers