Connect the Nots
Today I learned that you can’t adjust the font size in SQL Server Management Studio’s Object Explorer pane. Nor registered...
2015-04-02
622 reads
Blog Posts
Generating tSQLt tests from a dacpac
UPDATE I went and built this into my add-in for SSDT, more details https://the.agilesql.club/blog/Ed-Elliott/2015-11-17/Create-Stub-tSQLt-t… and https://the.agilesql.club/Projects/SSDT-Dev-Pack
Generating tSQLt tests from a dacpac I use SSDT and tSQLt in my work...
2015-04-02
2 reads
Generating tSQLt tests from a dacpac
Generating tSQLt tests from a dacpac
I use SSDT and tSQLt in my work and I am always interested in productivity...
2015-04-02
1,279 reads
Generating tSQLt tests from a dacpac
UPDATE I went and built this into my add-in for SSDT, more details https://the.agilesql.club/blog/Ed-Elliott/2015-11-17/Create-Stub-tSQLt-t… and https://the.agilesql.club/Projects/SSDT-Dev-Pack
Generating tSQLt tests from a...
2015-04-02
44 reads
Generating tSQLt tests from a dacpac
UPDATE I went and built this into my add-in for SSDT, more details https://the.agilesql.club/blog/Ed-Elliott/2015-11-17/Create-Stub-tSQLt-t… and https://the.agilesql.club/Projects/SSDT-Dev-Pack
Generating tSQLt tests from a...
2015-04-02
30 reads
Monitoring SQL Agent Jobs when you work for Mr Krabs
For those of you who don’t know who Mr. Krabs is, he is a character in the TV show Sponge...
2015-04-02
541 reads
Mr. Fox SQL Blog…
So I’ve decided that its finally time I took a bite out of the magic apple and started doing some Blogging. Starting a blog has been on my mind...
2015-04-02
7 reads
Mr. Fox SQL Blog…
So I’ve decided that its finally time I took a bite out of the magic apple and started doing some...
2015-04-02
480 reads
New Blogger Challenge 1 – Adding a Primary Key
The April Blogger Challenge is from Ed Leighton-Dick and aimed at new bloggers, but anyone is welcome. I’m trying to...
2015-04-02
808 reads
Procedure Creation – Correct Syntax, Wrong Database
Recently, on a Friday evening, we released an update to one of our core applications. As expected, it went smoothly...
2015-04-02
435 reads
Blogs
Did You Really Name That Default?
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
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...
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