Cloud Common Sense
Moving to the cloud, or any other type of outsourcing should be done with common sense, as Steve discusses today. That means keeping control of your backups.
Adding Custom Code to the Reporting Services 2008 R2
There are numerous circumstances when we wish to add a custom function to a SSRS report in order to cater for needs of the customer which exceeds the capability of the built-in functions in SSRS. In these scenarios we will have to write our own functions. In this article you will see how to add custom code to SSRS.
Architecture Career Paths for SQL Server Professionals
On Thursday September 15th, MCM Robert Davis will discuss the architect jobs and their meanings.
Jeff Moden elected Exceptional DBA of 2011
We are pleased to announce that Jeff Moden has been elected by judges and the SQL Server community as the Exceptional DBA of 2011.
Not on the Same Page
It seems that security staff and other technical people are not always on the same page. Steve Jones says that we should be working to take security more seriously.
Unique Indexes in SQL Server: Stairway to SQL Server Indexes Level 8
Indexes that ensure data integrity in addition to locating rows.
SQL Bits 9 - Query across the Mersey
Come join Steve Jones and many other SQL Server pros in Liverpool for SQLBits on Sept 29-Oct 1.
SQL Server Index Statistics
Are your index statistics up to date? The SQL Server database engine uses statistics to determine which execution plan to use when a query is compiled. Index statistics are used to help the SQL Server engine determine the cardinality of different column values in a SQL Server table. If you want to give SQL Server a fighting chance at picking an optimal execution plan then you need to make sure you maintain your index statistics.
Blogs
A New Word: los vidados
By Steve Jones
los vidados – n. the half-remembered acquaintances you knew years ago, who you might...
In-Person CISA Training – April 13-16, 2026
By Brian Kelley
I will be leading an in-person Certified Information Systems Auditor (CISA) exam prep class...
EightKB 2026
EightKB is back again for 2026! The biggest online SQL Server internals conference is...
Forums
query to track time spent on individual tasks in SSIS
Hi everyone I am looking at building a query to determine how much time...
SQL Server Transactional Replication from Always On Availability Groups to Azure SQL Database
Comments posted to this topic are about the item SQL Server Transactional Replication from...
Hidden Heroes
Comments posted to this topic are about the item Hidden Heroes
Question of the Day
Identities and Sequences I
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which are explicitly linked to increment a number in a table when a new row is added?
See possible answers