How to create DACPAC file?
In this post I will explain what the DACPAC is and how to create it. In previous post in DevOps...
2018-10-31
2,581 reads
Blog Posts
Installing Azure Data Studio
Azure Data Studio is the newest tool from Microsoft for working on the data platform. Last year we saw the...
2018-10-31 (first published: 2018-10-19)
4,486 reads
PASS Summit, SQLTrain and My First US SQL Saturday
Next week is the week when I used to dread looking at Twitter and especially the #PASSsummit hashtag, watching all of...
2018-10-31
258 reads
Speaking at PASS Summit
The title says it all, this year I have been selected as a speaker at the world’s largest Microsoft Data...
2018-10-31
260 reads
String or binary data would be truncated: get the full picture in SQL Server 2017
SQL Server 2019 Preview (CTP 2.0) introduced a long-awaited improvement to an error message that’s been around in SQL Server...
2018-10-31
508 reads
Email Alerts with SIOS DataKeeper
Over the past few weeks I wrote a 3-part series on how to configure email alerts based on Perfmon Counters,...
2018-10-30
80 reads
Invalid value given for parameter PASSWORD. Specify a valid parameter value.
I still use sp_help_revlogin to transfer logins between servers. I know there are other options, including a set of Powershell...
2018-10-30 (first published: 2018-10-17)
7,717 reads
The 5 Scariest Moments for a SQL Server Developer
Watch this week's video on YouTube
While families and friends are scaring each other this Halloween week with stories of ghosts and ghouls, I thought it'd be way scarier to talk...
2018-10-30
4 reads
The 5 Scariest Moments for a SQL Server Developer
Watch this week's video on YouTube
While families and friends are scaring each other this Halloween week with stories of ghosts and ghouls, I thought it'd be way scarier to talk...
2018-10-30
3 reads
Unexpected Shorthand Date Implicit Conversions
I do my best work in the mornings. Evenings are pretty good too once I get a second wind.
Late afternoon...
2018-10-30 (first published: 2018-10-23)
2,805 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