31 Days of SSIS – SQL Server Configuration (18/31)
31 Days of SSIS
The last post in the 31 Days of SSIS talked about the use of environmental variables. As...
2011-01-25
1,469 reads
Articles
How to Speed up MS SQL Reporting Services on First Run
I set up a new instance of MS SQL Server Reporting Services, but I noticed that it starts up very slow and I have to wait for ages to access the site. I also noticed that it is always slow when it has not been used for a certain period of time.
2011-01-25
5,452 reads
Read from the Right End of the Index: BACKWARD Scans
Optimizing queries is the most fun when you don’t need to add indexes. There’s nothing quite so nice as finding...
2011-01-25
1,467 reads
2011-01-25 (first published: 2010-12-02)
3,658 reads
TSQL Challenge 48 - Parse and evaluate Arithmetic Expressions using TS
This challenge is to parse and evaluate arithmetic expressions using TSQL.
2011-01-24
2,294 reads
Another Example of CPU Throttling Due to Balanced Power Plan in Windows Server 2008 R2
Here is another example CPU throttling from someone who had a server running with the default “Balanced” Power Plan in...
2011-01-24
2,725 reads
BIT of a Problem
The BIT data type is an awkward fit for a SQL database. It doesn't have just two values, and it can do unexpected things in expressions. What is worse, it is a flag rather than a predicate, and so its overuse, along with bit masks, is a prime candidate for being listed as a 'SQL Code Smell'. Joe Celko makes the case.
2011-01-24
3,676 reads
You Need Two SLAs for Disaster Recovery
Continuing on with my MCM prep, I was listening to the High Availability/DR prep module today and I was once...
2011-01-24
1,427 reads
31 Days of SSIS – Environmental Variable(17/31)
31 Days of SSIS
It’s time to go back to discussing the environment when it comes to SSIS packages. For the...
2011-01-21
2,830 reads
Getting Fast Counts of Large Service Broker Queues
Getting Fast Counts of Large Service Broker Queues
This question regarding getting a fast count from a service broker queue came...
2011-01-21
1,071 reads
Blogs
SQL Server Security: Always Encryption
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
A Las Vegas Break
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Identity Defaults
Comments posted to this topic are about the item Identity Defaults
Question of the Day
Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers