31 Days of SSIS – Create XML Document (13/31)
31 Days of SSIS
Day thirteen and we are trucking along with the 31 Days of SSIS blog series. The last...
2011-01-17
2,056 reads
Articles
Effective Clustered Indexes
As a guideline, clustered Indexes should be Narrow, Unique, Static and Ever Increasing (NUSE). Michelle Ufford Explains why.
2011-01-17
4,641 reads
SQL Saturday #45 - Louisville
A free day of training in Louisville, KY. Come and learn more about SQL Server from a variety of experts.
2011-01-17 (first published: 2010-11-30)
3,202 reads
Getting Started with SQL Azure Development
SQL Azure provides features similar to a relational database for your cloud apps. We’ll show you how to start developing for SQL Azure today.
2011-01-14
3,003 reads
A Collaborative Approach To Table Compression
A start at identifying and creating TSQL statements for tables that may benefit from compression.
2011-01-13
4,544 reads
31 Days of SSIS – Recursive SSIS Package (6/31)
31 Days of SSIS
As I mentioned in the introductory post, I’m writing 31 Days of SSIS. In the first post...
2011-01-13
1,866 reads
Trending Buffer Pool Performance Using DMV sys.dm_os_performance_counters
I'd seen you posted a tip on capturing SQL based PerfMon counters using sys.dm_os_performance_counters. What queries can I run against those stored results that would allow me to examine memory usage on my SQL instance?
2011-01-13
2,548 reads
Data Conversion in SQL Server
Most of the time, you do not have to worry about implicit conversion in SQL expressions, or when assigning a value to a column. Just occasionally, though, you'll find that data gets truncated, queries run slowly, or comparisons just seem plain wrong. Robert Sheldon explains why you sometimes need to be very careful if you mix data types when manipulating values.
2011-01-12
4,537 reads
Date Rounding Tactics and the Tiny Devil of SMALLDATETIME
Tiny Devils
With every new year I think a little bit about time and dates. This posts looks a little more...
2011-01-12
2,034 reads
DevWeek & SQL Server DevCon 2011
The 14th annual DevWeek conference takes place from 14-18 March 2011, at the Barbican Centre in central London, and once again incorporates two dedicated tracks on SQL Server, alongside seven concurrent tracks aimed at software developers.
2011-01-11
475 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