Scripts and SSDT-BI 2013
Recently I tried to open a script component in SSDT-BI 2013. I was developing for SSIS 2014, so this means...
2015-08-11
1,029 reads
Blog Posts
SQL Saturday Speaker Marketing – With Powershell
If you follow the Twitter account for SQL PASS, you probably noticed that they are actively promoting individual Summit 2015 speakers....
2015-08-11 (first published: 2015-08-06)
1,800 reads
T-SQL Tuesday #69–Encryption
This is a good T-SQL Tuesday topic for me. This month Ken Wilson asks everyone to write on encryption, which...
2015-08-11
907 reads
What is DBCC?
What is really mean by DBCC and what do people mean when they say DBCC?
Related Posts:
Database Corruption and IO Errors January 18, 2018
Common Tempdb Trace Flags - Back...
2015-08-11
41 reads
What is DBCC?
If I ask you what is DBCC, what would your answer be?
I want you to think about that one for...
2015-08-11
10,660 reads
Cleaning Your #PowerBI Power Query Code
Over the weekend I found this nifty tool called Power Query Management Studio. Someone shared it on Twitter and you’ve...
2015-08-10
601 reads
Iterate Over Web Pages Using Power Query
Power Query makes it easy to pull data from a web page. As easy as deflating a football. Poof. Gone. However,...
2015-08-10 (first published: 2015-08-05)
3,912 reads
To AutoGrow or not?
Note: This is a repost of an older blog by Sean that’s still applicable. We’ve updated it with a note...
2015-08-10
747 reads
Using Qure Profiler To Benchmark Tuning Progress
the problem of monster views
I’ve been working with tuning an application that performs a lot of Entity framework calls,...
2015-08-10
1,330 reads
An interesting setting for NULL but don’t use it for future TIP #109
As we discussed earlier in TIP#103 for NULL in which I shared that we have to take extra care for...
2015-08-09
548 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