Resume Generating Event (RGE)
No, I haven't lost my job. This is just one of those topics that's good to get out there. There...
2014-04-28
1,217 reads
Blog Posts
Sorkin On Writing
I saw this write up about Aaron Sorkin and the writing on Newsroom just after posting Blogging-Write More and found...
2014-04-28
638 reads
The default autogrowth settings do NOT come from the Model database.
I recently saw a question about How to inherit autogrowth settings. They commented that while the new database GUI seemed...
2014-04-28
1,149 reads
Video: Designing Stored Procedure Solutions
My new session for 2014, “Designing Stored Procedure Solutions”, is now up on the Sessions page: abstract, video, and code!...
2014-04-28
1,236 reads
Why Can't I Reinitialize My Subscriber?
I recently had a colleague request help with a replication problem he was having with a client. The client was...
2014-04-28
3,365 reads
2014-04-27
SQL Agent Error During Windows Failover Cluster Setup
Problem: You had just finished up installing cluster setup in your Primary node. After verifying your setup is complete and...
2014-04-27
811 reads
When issue is not exactly "issue"
In last release of SQL Code Guard (2.4.5222) I've added few issues which can cause confusion.Eg - ST012 "Consider using temporary table instead of...
2014-04-27
560 reads
New Permissions in SQL Server 2014: IMPERSONATE ANY LOGIN, SELECT ALL USER SECURABLES, CONNECT ANY DATABASE and the old CONTROL SERVER
(DE)
SQL Server 2014 bringt insgesamt 5 neue Berechtigungen. Zwei von diesen sind auf Datenbank-Ebene und nur in der Windows...
2014-04-26
2,491 reads
DAX #1 – Learning DAX
I recently attended a virtual training of Tabular and Power Pivot for Developers taught by Kathy Vick at Pragmatic Works....
2014-04-25
1,893 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