SQL Cop and SQLServerCentral
Steve Jones runs the SQL Cop tests against the SQLServerCentral database and looks at the results.
2015-03-23
5,223 reads
SQL Cop
Prevent sp_ Procedures with SQLCop
Learn how you can use SQLCop to prevent your developers from writing stored procedures that are named sp_ something.
2015-01-15
6,021 reads
Select Max of sum
I want to get the maximum of sum with one select statement. The database is NorhtWind and this is the query. select orderid, sum(quantity) from [order details] where orderid between 11000 and 11005 group by orderid order by 2 desc I know that i can use this statement: select Top 1 orderid, sum(quantity) from [order […]
2004-06-15
2 reads
SQLCentric monitoring software - Save $$$$ now - 15%
Pre-summer Sale - Save hundreds of dollar$ now - 15%Pearl Knowledge Solutions, Inc. is having a Pre-Summer Sale! From now, through July 15, 2004, we are offering a 15% (fifteen percent) discount on SQLCentric server license kits, which will save you hundreds, even thousands, of dollars on the cost of monitoring your SQL Servers.For more details […]
2004-06-08
1 reads
Blogs
Set a Runtime Variable in an Azure DevOps Pipeline
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
A New Word: Symptomania
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
Query Store Keeps Switching Itself Off, Getting it Moving Again
I recently received a complaint that Query Store for a particular database was turned...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers