Latest Blog Posts
Today we all received an email from PASS's president Tom LaRock (blog/@SQLRockstar):
It’s Tuesday time for this week’s one day late blog and twitter round-up for last week. If you haven’t already, follow me on twitter (@StrateSQL). This is a good chance to catch up on data platform technology and career related information I’ve shared in the last week and… Read more
Take a minute and look around you. Automation is all around you; whether you see it or not processes are automated on all levels of life.
One thing that I’ve noticed among professionals is that “change” is very difficult; while others do not know what to automate.
Time and Value Read more
Installing and configuring SQL Server Master Data Services (MDS) is like a box of chocolates: you never know what you’re gonna get. Recently I ran into some troubles (or woes) when configuring MDS at a client. The installation went smoothly, as well as the installation of other prerequisites (like… Read more
SSDT is great but one thing that is not so great is the performance of the publish. I am not complaining, I understand it does a lot and is well worth the wait when publishing however, when you are writing and testing code having this process really kills productivity:
Let's go back to…
0 comments, 116 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 24 November 2015
The ScriptDom is cool, it lets you parse T-SQL, play around with the AST (tree of statements) and then generate T-SQL again (probably in a different format etc). This is really cool but if you round-trip the T-SQL into an AST and back you lose some important information like comments…
Continuing on with my Partitioning post series, this is part 7.
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…
The transaction log is made up of one or more files that are used sequentially. So in other words if you have multiple log files then new log information will only be written within one of those files at a time.
To the best of my knowledge there… Read more
When developing stored procedures in SSDT it is important to know when you have written a query that is potentially slow or has a high IO or CPU cost but there is no real way other than examining the the tables you are querying and understanding the data volumes and…
A few days ago I returned from PASS Summit 2015 (and a vacation I took afterwards).
Here’s my recap:
I opened the week with a FreeCon Brent Ozar and Kendra Little hosted.
The day focused on personal branding and the learning and sharing paths that are derived from it.
In… Read more
One of the projects that’s been on my list lately is to programmatically access Twitter for a few ideas I want to play with. Since I’ve been trying to learn some Python, I thought I would take a look using Python to update status and read status.
A quick Google… Read more
As a DBA, I have a collection of scripts that I use for anything from auto-fixing logins to seeing who has the DAC. Since I’ve been a DBA for a while (yeah, a while, we’ll go with that) I have quite the collection of scripts and I am constantly adding… Read more
SQL Server Reporting Services (SSRS) is getting quite the overhaul in SQL Server 2016. Lot’s of things are changing:
- new look ‘n feel for Report Builder: Report Builder Changes in SQL Server 2016
- new chart types (check out my sunburst, treemap and heatmap articles)
- a (somewhat) customizable parameter pane
I was always challenged when my customers asked me what tables and columns are referenced by a stored procedure which was written many years ago by the guy who left the company 5 years ago. When I Google the solution, I was always told that
sys.sql_expression_dependencies can tell.… Read more
If you use SQL Server Data Tools (SSDT) and SQL Server Data Tools – BI (SSDT-BI) for your SQL Server 2012 development, then you have no doubt been frustrated, like me, by the fact that if you have both of these installed you no longer have the ability to create… Read more
Quite often, I output information through PRINT command. It works well only when message is shorter than 8000 bytes. When the message is greater than 8000 bytes, extra-characters will be removed. the simplest way to overcome this is to make a loop and print 8000 characters at a time