Latest Blog Posts
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
Last week’s PASS Summit conference in Seattle, WA was incredible (as always). It’s my favorite tech event of the year, and I’ll never miss it. The SQL Server community is one of the strongest (and arguably the most tight-knit) technical community in the world, and the #sqlfamily comes together every… Read more
SQL Server Community Technology Preview 3 has been released some days ago.
The SQL Server team added a lot of features related to:
- SQL Server Engine (Query Store, Temporal Tables and In-Memory improvements)
- Cloud-ready stuff (Transactional replication from and to Azure SQL Databases, Stretched database enhancements)
- New releases of Management…
What is the ScriptDom?
The ScriptDom is an api for taking t-sql scripts, converting them into an AST or taking an AST and generating t-sql.
What is an AST?
Think about this:
select col from tablea
select col from tablea
select col /*from not_table*/ from tablea
Thanks to everyone who participated in week 1 of the SQL New Blogger Challenge! Eight posts were written this week and linked on Twitter (#SQLNewBlogger), and I think I saw some that weren’t tweeted with our hashtag. That’s a great first week!