Trapping Online Index Operations
Recently I wrote an article about Capturing Online Index Operations. In that article, I discussed a problem that I had...
2015-01-29
1,327 reads
Blog Posts
ASP.Net MVC File Stream, Initiated From Javascript Post
I was recently working on a page that does an AJAX post to an MVC controller passing quite a lot...
2015-01-28
261 reads
Excel BI Tip #17: Using the Timeline Filter
As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...
2015-01-28 (first published: 2015-01-20)
6,861 reads
New Power BI Preview and Pricing
Some exciting announcements were made today about the new Power BI cloud-based business analytics service. Today Power BI is an...
2015-01-28
583 reads
Oh Look, A Horseless Carriage
Never forget, we’re making buggy whips. And everybody we know drives little buggies and they need our buggy whips. We’ve...
2015-01-28
1,081 reads
Out of Space
I’ve used placeholders to ensure I don’t run out of space on my machines. That’s worked well, and usually I...
2015-01-28
1,262 reads
SQL Saturday 360 in Israel
I had the pleasure to speak at SQL Saturday 360 in Israel. It was such a great event! We had...
2015-01-28
605 reads
Statistics Parsing
Never really enjoyed reading through the statistics IO results, as it makes it hard to easily guage total impact when...
2015-01-28 (first published: 2015-01-21)
6,740 reads
DoD STIGs – Database Security Requirements Guide
Reading Time: 24 minutes
What are the Database SRG DoD Stigs?
The Database Security Requirements Guide, or SRG, is published as a...
2015-01-27
2,998 reads
Entity Framework 6 Interceptors
Interceptors in Entity Framework 6 allow you to hook in to before and after query events. The before events even...
2015-01-27
378 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