T-SQL Formatting Workaround (Word Macro)
Hi all! I’m on vacation this week, but I’ve cleverly scheduled this blog post so you won’t miss me too...
2011-06-20
1,566 reads
Blog Posts
Presenting Two Sessions at PASS Summit 2011
I found out earlier this week that I was fortunate enough to have my half day session on “Scaling SQL...
2011-06-19
916 reads
Ice Cubes and Top SQL Rally Speakers
That title may evoke thoughts of inappropriate SQL Karaoke or perhaps not but It is so nice to know I’m...
2011-06-18
864 reads
Prevent SQL Logins from using SSMS … or any other app
In a continuation of my previous LOGON TRIGGER post.
A downside to SQL logins is that anyone with the username / password...
2011-06-18
2,135 reads
SSAS Maestro - Redmond Recap
Well today was the last day for a while I would be greeted by this sign:
It was a pretty exciting...
2011-06-18
850 reads
Altering Table structure - SSMS - Timeout Expired
Altering a table using SQL Server Management Studio ( SSMS ) can be done by right clicking on the table and by...
2011-06-17
363 reads
An Update on My Dell E6500
I bought my E6500 almost three years ago, giving away what was a perfectly good Latitude to trade up to...
2011-06-17
560 reads
Being Cautious With SQL Based Processes
Why being careful is such an important mindset when working with SQL and databases.
At the Boston Public Schools, certain processes...
2011-06-17
1,141 reads
Itzik Ben-Gan is in town
Not that you would know it from the page below, but Itzik Ben-Gan is back in London to do a...
2011-06-17
1,284 reads
Re-blog – June 10-June 16
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Oddly enough,...
2011-06-17
480 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