SQL Server Resource Governor
Using Resource Governor on a SQL Server that suffers from CPU contention thus allowing us specify limits on the amount of CPU that an incoming request can use.
The Practical Problems of Determining Equality and Equivalence in SQL
In theory, it is easy to determine whether data is equal to, greater than or lesser than a value. Real-world data types can be surprisingly tricky, even for gauging data equivalence. Because SQL cannot remain aloof from any application's data types, you need to be aware of the ways and pitfalls of individual datatypes and how you can test for equality, equivalence, similarity, identity and all that jazz. Joe Celko discusses.
A nice whistle and flute
Phil Factor recounts the most important lesson of his early IT career: try not to burst into giggles when you get to look at the client's IT system.
Verify SQL Backups With SQL Powershell
With SQL Powershell, you can check all your database backups in minutes, whether you have ten SQL servers or 100.
Knee-Jerk Performance Tuning: Incorrect Use of Temporary Tables
Paul Randal continues his knee-jerk performance tuning series, focusing on ways to optimize performance when using temporary tables.
Automatic SSRS report output of all report parameter combinations
You already have a SQL Server Reporting Services (SSRS) sales report that takes parameters for Country and State. Each time the report is run a user selects the specific Country and State for the report. A request has been made to deliver one report via email that includes all of the combinations for each country and state. Daniel Farina shows how to achieve this without modifying the report.
Migrating an on premise SQL Server Database to Azure
For this article I want to show you how to import a BACPAC file to create a new Azure SQL Database which is Microsoft’s Platform as a Service(PaaS) offering.
Blogs
SQL Server Journey Part 2: Modern Era (2017 – 2026) – AI/Cloud First
By Vinay Thakur
Following up on my Part 1 baseline, the journey from 2017 onward changed how...
Google Moves Up Post-Quantum Cryptography Timeline
By Brian Kelley
In cryptography, the RSA and ECC algorithms which we use primarily for asymmetric cryptography...
The Book of Redgate: No Politics
By Steve Jones
In today’s world, this might mean something different, but in 2010, we had this...
Forums
Dancing Robot Goes Rogue
Comments posted to this topic are about the item Dancing Robot Goes Rogue
advice as i migrate my winscp based ssis pkg to our prod server
Hi , i installed winscp on my pc, added it to GAC thru vs...
Identities and Sequences II
Comments posted to this topic are about the item Identities and Sequences II
Question of the Day
Identities and Sequences II
In thinking about the differences between the identity property and a sequence object, which of these two guarantees that there are consecutive numbers (according to the increment) inserted in a single table?
See possible answers