Latest Blog Posts
There are some improvements in the setup UI for SQL Server 2016 CTP3, and its great to see Microsoft making these changes as they receive feedback from multiple customers and early adopters.
My earlier post on setup UI changes for CTP 2 is available here.
The 1st change is… Read more
I ran into Sebastian Meine at the PASS Summit a few weeks ago and we were talking testing. Sebastian is the founder and developer of tSQLt, which I really like using. We’ve done some teaching together and I’ve delivered a number of sessions on tSQLt at various events, but… Read more
Earlier this week I received a great question from a friend, and read something like this.
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as#SQLNewBloggers.
I wrote recently about adding extended properties. Updating them is very similar. There’s an analogous procedure called sp_updateextendedproperty that changes the value of properties.
The arguments are… Read more
Today I had on my list to finish watching the presentation Gail Shaw did at Summit 2014, one of the free recordings on PASS TV. I don’t remember it from before, but I was prompted to fill out a short demographic form. Ok, I get it. Then I get to… Read more
Red-Gate published new version of its SIPF framework with support of SSMS 2016!
Now you can simply download and install SIPF from Red-Gate's site http://documentation.red-gate.com/display/MA/SSMS+ecosystem+project - and you'll be able to use SQL Code Guard and ExpressProfiler from SSMS 2016!
Great job, Red-Gate! Awesome as always!
Here’s an excerpt from an email from PASS I received on November 4 and also available at this link (bolding added by me):
The PASS BA Conference answers the call to meet the unique needs of business and data analysts, who are asked to do more with data every day.…
This month Mickey Stuewe hosts the T-SQL Tuesday and she has a great topic. Data Modeling is something few people seem to do, especially developers, and it often can go wrong. That’s the topic, and I have a short story.
T-SQL Tuesday is a monthly blog party, on the… Read more
T-SQL Tuesday is here again. I’ve had good intentions the past few times this event has come around and even have drafts still waiting to be queued up which I will eventually turn into regular blog posts, but I decided to just make time this month and jump back into… Read more
I was renewed for another year as a SQL Server – now Data Platform – MVP, always pleasant news. My plan for the new MVP year is pretty much the same as last year, I’ll try to out and about serving the Florida community, doing some mentoring, and contributing to… Read more
I’m late posting this, I wrote six questions after doing a refresh of what I knew (or should have known) about filetables:
- Backing Up to a Filetable
- Filetable and Non Transacted Access
- Filetable File Lengths
- Filetable Insert Triggers
- Filetable Trivia
- Nulls in the Filetable
It’s almost Thanksgiving time again! Let’s see, what am I thankful for? T-SQL Tuesday! Someone else get’s to pick a blog topic for me! In this case it’s the always fun Mickey Stuewe(b/t) and her topic is Data Modeling Gone Wrong. So let’s see ..… Read more
Well I’m not a data modeler, nor do I play one in the corporate world. But it is TSQLTuesday No. 72, and I have my tales to tell. Mickey Stewe, (b|t), aka @SQLMickey, database architect, whose focus is on data modeling, has invited… Read more
Continuing on with my Partitioning post series, this is part 6.
The partitioning includes several major components of work (and can be linked below);
- partitioning large existing non-partitioned tables
- measuring performance impacts of partitioned aligned indexes
- measuring performance impacts of DML triggers for enforcing partitioned unique indexes
- rebuilding tables…
I’ve written a few posts on the Redgate Software blog to try and show how I see the DLM model, and how we see things at Redgate. We have a lot of developers that work in a similar way when building application software in C#, Java, Python, or other languages,… Read more
It’s Monday time for this week’s blog and twitter round-up for last week. If you haven’t already, follow me on twitter (@StrateSQL). This post provides a good chance to catch up on data platform technology and career related information I’ve shared in the last week and activity on… Read more