This paper provides an overview of the primary changes made to the cardinality estimator functionality by the Microsoft query processor team, covering how to enable and disable the new cardinality estimator behavior, and showing how to troubleshoot plan-quality regressions if and when they occur.
SSC's Steve Jones will show you how Redgate's DLM solution works to improve your database development and deployment processes. You'll see how to version control your databases from SSMS to track and understand changes, include your database in your Continuous Integration process to get quick feedback, automate your database deployment process to have safe, reliable, repeatable deployments, and more.
Using SQLCMD Mode in SSMS is easy. This short piece will show you how to get started.
To mark five years in business helping companies across the United States with their SQL Server needs, SQL Solutions Group will host a day of free SQL training Tuesday, Oct. 27, in Seattle.
The age old question of where should business logic be stored
Describes the idle connection resiliency feature, which allows ODBC and SqlClient data access applications to maintain their connections to SQL Server 2014 or an Azure SQL Database.
What should those accidental DBAs do when they don't get any training, but they are responsible for database servers? Steve Jones has a few pieces of advice today.
At the time of writing, SQL Server 2016 preview (CTP 2.3) has been released and there are some changes for the Integration Services (SSIS) Catalog logging levels.
A quick tip to help you get the most out of SQL Prompt.
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...
WhatsApp: 0817839777, Jl. Raya Kendangsari Industri No.2, Kendangsari, Kec. Tenggilis Mejoyo, Surabaya, Jawa Timur...
WhatsApp: 0817839777, Jl. Brawijaya No.8, Pocanan, Kec. Kota, Kota Kediri, Jawa Timur 64123
WhatsApp: 0817839777, Jl. Dr. Ir. H. Soekarno No.37-39, Klampis Ngasem, Kec. Sukolilo, Surabaya, Jawa...
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