T-SQL Tuesday 31: SSIS 2012 Logging
Topic for this month’s T-SQL Tuesday, hosted by Aaron Nelson (@SQLVariant) is Logging.
I like to think of logging as a...
2012-06-19 (first published: 2012-06-12)
3,795 reads
Blog Posts
Two New Cumulative Updates for SQL Server 2008 R2
Microsoft has released two new Cumulative Updates for SQL Server 2008 R2. The first one is SQL Server 2008 R2...
2012-06-19
1,129 reads
X-XMLA: iv. Deploying Databases with XMLA
The fourth segment in this series focuses on using XMLA to deploy databases. When you create SQL Server Analysis Services...
2012-06-19
907 reads
Colorado SQL - June 2012
All ColoradoSQL user group meetings start at 5:30 p.m. and provide food and refreshments. There is no cost to attend...
2012-06-18
768 reads
Determine Index Fragmentation in a SQL Server Database
Index fragmentation can adversely affect query response time. When accessing data through an index, SQL Server must read each page...
2012-06-18
9,148 reads
Exceptional DBA Awards 2012
Reprinted from my editorial in the Simple-Talk Newsletter.
It’s hard to believe, but it was five years ago that Red Gate Software...
2012-06-18 (first published: 2012-06-11)
2,044 reads
Failover consederations on Database Mirroring
These topics will give you the brief idea of what happens behind the scenes during failover occurs in Database mirroring....
2012-06-18
1,226 reads
File Extensions for SQL Server Database Files
I was reading an article over the weekend where the author pointed out that the standard naming convention for SQL...
2012-06-18
1,616 reads
Holiday
Sort of.
I’m off for a week to Camp Alexander near Pikes Peak for Boy Scout summer camp. My 13year old...
2012-06-18
846 reads
Login failed for [SQLSTATE 28000] (Error 18456) the step failed
AdvertisementsLogin failed for [SQLSTATE 28000] (Error 18456) the step failed
When you query the data from another SQL server (Linked server)...
2012-06-18
53,062 reads
Blogs
Advice I Like: Rewards from Work
By Steve Jones
The greatest rewards come from working on something that nobody has words for. If...
Overcoming Challenges: Navigating Common Pitfalls in FinOps Adoption
By HeyMo0sh
Working in DevOps, I’ve seen FinOps do amazing things for cloud cost control, but...
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
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...
Creating a Simple and Flexible Random Password Generator in SQL Server
Comments posted to this topic are about the item Creating a Simple and Flexible...
SQL Art, Part 3: Happy Easter Fun in SSMS
Comments posted to this topic are about the item SQL Art, Part 3: Happy...
Question of the Day
Identities and Sequences IV
When thinking about the identity property and sequence objects, which of these can be used with numeric and decimal data types?
See possible answers