Latest Blog Posts
Sometimes Fast & Dirty is OK. Other times, not so much. Sometimes...
We're a little under 3 weeks away from what is sure to be the biggest and best Big Apple SQLSaturday event in NYC, on May 30, 2015! It is with great pleasure to announce the SQLSaturday#380 super SQL Server Speaker Schedule!! Indeed we have an exciting and awesome lineup… Read more
“Is there any way to start a SQL Agent job using a script or program?”
I’ve seen this question asked a number of times over the past couple weeks and I thought I would share an approach using PowerShell and SMO. But first, let’s take a step back… Read more
Let’s say you remember a piece of code you need to optimize or take a look at, but you don’t remember in which stored procedure you saw it.
The following script searches for a certain string inside the code of all programmatic objects in the database (stored procedures, triggers, views… Read more
Recently, I was able to help SimpliVity work to develop a reference architecture document for running resource-intensive SQL Server virtual machines on the SimpliVity OmniCube platform. We went through a lot of different OLTP workload types and have put together a number of best practices for virtualized SQL Server on… Read more
If a user is going to call me about problem, I’d much rather know about it ahead of time. In fact my favorite problems are the ones I’ve already fixed before the users ever notice it. In order to manage this amazing feat you have to monitor your instances, your… Read more
Cathrine Wilhelmsen (b|t) is hosting this month’s T-SQL Tuesday, and the topic she chose is monitoring. All of us, whether a DBA or a developer, internal resource or consultant, monitor something on a daily basis. The hardest part for me was deciding what to write… Read more
Just heard that today was T-SQL Tuesday #66! Well, I knew it was Tuesday, and T-SQL comes into play once a month, but then I heard the topic was monitoring. I am so pleased that Cathrine Wilhelmsen (@cathrinew) is hosting this month’s blog party, and I… Read more
If you’ve read my blog or attended one of my presentations before, you almost certainly know that I’m a huge fan of Biml. If you’re building or maintaining SSIS packages (or you’re supervising those that do), you owe it to yourself to learn about Biml. I don’t make a lot… Read more
This is a T-SQL Tuesday that not only makes me smile, but makes my boss happy. In fact, I’m sure that quite a few people at Redgate Software, my employer, are thrilled with this topic since we have a product that helps you here: SQL Monitor.
Thank you Cathrine Wilhelmsen for hosting this week’s #tsql2sday.
If I knew that this T-SQL Tuesday was going to be about monitoring I would have saved my Monitoring SQL Agent Jobs post from last month. No worries though! I think I’ll talk more generally about monitoring.
If you don’t monitor…
Cloud Service ModelsThere are three main service models in the cloud. You will see these buzz words being used a lot in cloud discussions:
- IaaS - Infrastructure as a Service
- PaaS Platform as a Service
- SaaS Software as a Service
Last week, I took the 70-461: Querying Microsoft SQL Server 2012 exam. I decided recently to try and achieve getting my MCSE: Data Platform certification within the next six months. Taking this exam was step one, and now I have four remaining. Rather than spending a bunch of money on… Read more
A big thank you to Cathrine Wilhelmsen (blog | twitter) for hosting this month’s TSQL2sday party. Monitoring is this month’s topic and it’s a very important one. It could mean the difference between having a job and looking for a job.
When I started working with SQL Server… Read more
Alerts have been around for as long as I can remember, so some time before breakfast. That probably means you need to get a wriggle on and upgrade to SQL Server 2014. If you are still wondering whether to upgrade I did write a post on it some time back… Read more
Introduction to SQL server Objects
In databases, when we talk about database objects, it means we are talking about SQL Tables. SQL Tables are also known as SQL Objects which manages all the records in a specific order in SQL server database. The data, stored in a Table are managed… Read more
You know, these 1 hour sessions that are at most SQL Saturdays are just too short sometimes – you just get going and bang! The times up. There’s only so much material that can be presented in just one hour. And if there are a lot of questions, you may… Read more
It’s Monday time for this week’s weekly 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 activity on… Read more