T-SQL Tuesday #005 – Offloading Reporting (#TSQL2sDay)
Aaron Nelson (Blog|@SQLvariant) is hosting this months #TSQL2sDay with the theme of reporting. My post looks at some of things...
2010-04-13
670 reads
Blog Posts
T-SQL Tuesday #005 – Self Service Performance Information
Introduction
Today I am taking a little detour from the scripts I have been posting to take part in “T-SQL Tuesday...
2010-04-13
435 reads
T-SQL Tuesday #005: Monitoring Reports with SSRS
This post is a T-SQL Tuesday Entry, hosted this week by Aaron Nelson on the topic of “Reporting”. (It got...
2010-04-13
1,057 reads
T-SQL Tuesday #005: Smart Card Login Breaks SQL Server 2008 Reporting Services
T-SQL Tuesday #005: Smart Card Login Breaks SQL Server Reporting Services 2008
This blog entry is participating in T-SQL Tuesday #005,...
2010-04-13
3,427 reads
T-SQL Tuesday #005: SSIS Reporting
Automating SQL Server Integration Services (SSIS) administration through PowerShell is very different than writing scripts against the core database engine....
2010-04-13
1,192 reads
Visual Studio 2010 Ultimate RTM Available and Installed
Microsoft’s Scott Guthrie had a good post up yesterday that highlights some of the new features in Visual Studio 2010....
2010-04-13
507 reads
A DMV a Day – Day 12
The DMV for Day 12 is sys.dm_db_partition_stats, which is described by BOL as:
Returns page and row-count information for every partition...
2010-04-12
844 reads
April OPASS Meeting Featuring Joe Webb
Tomorrow night, April 13th, at 6pm we will be having our April OPASS meeting, sponsored by Veredus Orlando with Joe...
2010-04-12
437 reads
Book Review: Crush It!
Not long ago, I read a review of Gary Vaynerchuk’s book, Crush It! The reviewer, Michael Hyatt (Twitter | Blog), liked...
2010-04-12
471 reads
Bug: Reporting Services 2K8, SSMS and Windows 7
[Edit] Since writing this, I've realized that the true reason behind this was that my account was not a member...
2010-04-12
1,125 reads
Blogs
Case Studies: Real-World Success Stories of FinOps Implementation
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
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...
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