SQL Server “Denali”: Installing SSAS Multidimensional vs Tabular Mode
As I play with the recently released CTP3 of SQL Server Denali, I wanted to point something out about installing SSAS, since...
2011-07-15
1,917 reads
Blog Posts
SQL Server 2008 R2 Developers Training Kit
If your looking for presentations, demos, hands-on labs and videos to help you better understand SQL Server 2008 R2, then...
2011-07-15
486 reads
Tracking table changes seamlessly with Change Data Capture (CDC)
I am going to describe quite forgotten feature in SQL Server 2008. It is Change Data Capture (CDC) – powerful feature...
2011-07-15
2,514 reads
Bad Admins: Stealing An Account
Yesterday I posted about manipulating group membership to get access to a SQL Server. Today comes attack vector #2: stealing an...
2011-07-14
1,191 reads
Effective Permissions on a Database
written by David Postlethwaite
Ever wondered who has what access to your database or a particular object within? With the ever...
2011-07-14
2,324 reads
How to move the TempDB Database
Note that TempDB is recreated every time SQL starts. Why is this important? It means we don’t have to move the...
2011-07-14
747 reads
Office Work
I have been working at home for over 8 years, sharing an office with my wife for most of that...
2011-07-14
1,736 reads
Profiled on SQLPeople
I’m late posting it, but I was featured on SQLPeople for June 27th. It’s a project Andy Leonard has going...
2011-07-14
528 reads
SELECT INTO and IDENTITY (or, BOL is Sorta Wrong)
I am easily distracted. Lucky for all of us, I tend to be distracted by cool tidbits in SQL Server...
2011-07-14
971 reads
Send SSRS subscription files to (Secured FTP) SFTP
We have set up subscription for customer which used to send mails to the customers periodically. Recently one of the...
2011-07-14
3,910 reads
Blogs
Monday Monitor Tips: A New Analysis Page
By Steve Jones
We have multiple teams (8) working on Redgate Monitor. Some work on the Standard...
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...
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