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
Blog Posts
Friday Followup For April 25, 2014
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2014-04-25
321 reads
From where does SSMS get its database defaults?
We can create a database simply by typing in the command createdatabase DB1
We don’t have to provide any other...
2014-04-25 (first published: 2014-04-16)
2,368 reads
Out for a day
I’m hoping I’m only out for a day. As I write this, I’ll be recovering from my ACL surgery, though...
2014-04-25
643 reads
Powershell Goodies
If you haven’t seen some of the other blog post, or the Microsoft Powershell Blog, Microsoft recently release Script Browser for...
2014-04-25
1,684 reads
Reblog: April 18 to April 24
Photo credit – JStove
Old posts are like unicorns. You might see them just once, but it’d sure be nice to have...
2014-04-25
1,324 reads
Why does my Failover Cluster Instance Keep Failing Back and Forth?
A few months ago I was paged by a client because their SQL Server Failover Cluster Instance (FCI) was experiencing...
2014-04-25 (first published: 2014-04-17)
8,117 reads
Another Question Of the Day
Yesterday I submitted a new question of the day based on the best idea generator you can find – something that...
2014-04-24
562 reads
Journey of an On-Premises DB to Azure VM – SQL Server 2014 makes it easier!
SQL Server 2014 is deeply integrated with Windows Microsoft Azure and moving an On-prem database to a Microsoft Azure VM...
2014-04-24 (first published: 2014-04-16)
1,949 reads
Microsoft Azure Automation
Microsoft just announced a new mechanism for managing your Azure resources, Automation. You can check out the documentation on it...
2014-04-24 (first published: 2014-04-16)
1,781 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