Prefixated
Are you a prefixer? And by that I mean a developer – or DBA – who uses prefixes on object names? [DISCLAIMER:...
2018-09-24
260 reads
Blog Posts
Them Con+cat+enatin’ Blues
We ran into a funny problem not long ago, revolving around a stored procedure that was building up a dynamic...
2018-09-24 (first published: 2018-09-13)
3,199 reads
Using Table Valued Parameters with sp_executesql
Recently I did a presentation on dynamic SQL. In the presentation I pointed out the similarity of using sp_executesql to...
2018-09-24 (first published: 2018-09-13)
3,818 reads
Where to watch Ignite
In case you aren’t familiar with #MSIgnite, it’s a huge event where Microsoft debuts all the new shiny software that...
2018-09-24
266 reads
3rd Edition, SQL Server Execution Plans, a Story
Four years ago, after a bunch of dithering and some negotiations with Tony Davis, my editor, I started to update...
2018-09-21 (first published: 2018-09-12)
1,892 reads
Azure Integration with Flow
Today I’m talking more about integration with Flow within Azure. Flow is focused around business power users who need to...
2018-09-21
272 reads
Best Trick to Extract Data From SQL Server MDF File Instantly
SQL Server is a relational database management system in technology field it supports more than one transaction processing. MDF is utilized to save information like views, stored information and...
2018-09-21
28 reads
Best Trick to Extract Data From SQL Server MDF File Instantly
SQL Server is a relational database management system in technology field it supports more than one transaction processing. MDF is...
2018-09-21
10,319 reads
How to create a presentation in 30 easy steps
As I mentioned previously, this week I presented my first public SQL Server training session. I’m truly grateful for this opportunity because after all the work I put into...
2018-09-21
9 reads
Importing Flat Files in SSMS 17.x Works
One of the more annoying things I’ve found in SSIS/SSMS is trying to import CSV files for some quick analysis....
2018-09-21 (first published: 2018-09-12)
2,295 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