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.
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.
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.
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.
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".
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.
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.
Steve Jones looks at the dilemma of training developers and having them leave, or maybe, just having them stay untrained.
A quick tip for using a combination of block and line comments to test CTEs
Reading tutorials is fine. Shipping something is better. If you are trying to break...
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Comments posted to this topic are about the item Liability for AI Errors
Hello , I would like to run a stored procedure on a secondary replica...
Comments posted to this topic are about the item Pro SQL Server Internals
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers