It sometimes pays to go back and look at what you think you already know about SQL. Joe Celko gives a quick revision of the GROUP BY and HAVING clauses in SQL that are the bedrock of any sort of analysis of data, and comes up with some nuggets that may not be entirely obvious.
Changing Database Collation Through Primary keys, Foreign Keys, Default and Check Constraints and more.
SMO gives every appearance of being a great example of over-reliance on automated testing at the expense of manual exploratory testing.
Hear from Microsoft engineering experts on the latest features in SQL Server 2016 before the live event. Learn about new business intelligence capabilities like built-in mobile BI, fully integrated advanced analytics, security innovations, mission critical in-memory performance and new hybrid cloud solutions.
Aaron Bertrand (@AaronBertrand) revisits the impact that eliminating DONE_IN_PROC messages using SET NOCOUNT ON may or may not have on query performance
Learn about how to build value driven analytics with SQL Server and R.
Today we have a guest editorial from Andy Warren that examines the costs of family at work.
A UDF is very convenient for centralising business logic as we can specify a set of business logic in one UDF which references multiple stored procedures and ad-hoc queries. However, they can lead to significant performance degradation due to their demands on the CPU
Just because we can view the source code for software doesn't mean it is more secure.
By Brian Kelley
If you are considering any of the ISACA AI certs like the Advanced Artificial...
By ChrisJenkins
Are you currently using Microsoft Fabric or considering migrating to it? If so, there...
By SQLPals
Track SQL Server Configuration Changes Using the Error Log If you...
Comments posted to this topic are about the item Designing SQL Server ETL Pipelines...
Comments posted to this topic are about the item Detecting Deadlocks Quickly
We have a SQL Server installed. We have a 500GB drive for the database....
In the Database Engine, when a deadlock is detected, what does the detection interval shrink to (in time)?
See possible answers