Archives: June 2014
I’ll be doing a precon for SQLSaturday #324 in Baton Rouge Louisiana on August 1st, 2014 titled “A Day of High Availability and Disaster Recovery” . If you can make it, I would love to have you in the class. We are going to cover backups, windows clustering, AlwaysOn Failover… Read more
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (
so exciting), follow me on twitter (@StrateSQL). And see these throughout the day as I tweet out links of things I find interesting. While these links aren’t the answer… Read more
The SQL PASS Summit 2014 community sessions were recently released. I’m very pleased and honored to announce that I will be presenting a 75-minute session entitled “Right Sizing Your Virtual Machine” at the Summit this November. It’s a topic that I spend many hours a week on… Read more
I no more than finished my rant from last week than I started thinking about all the reasons why a healthy chunk of the reasons that developers want to bypass relational database is not the horror of the relational database itself, although, that’s there. No, a very large reason why… Read more
One of the most powerful tools we have as users of SQL Server is Books Online (BOL). Whether you work mainly as an admin, a developer or in BI, Microsoft has provided a HUGE amount of information for you to use. But BOL is by no means your only resource… Read more
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.)
I like to move it, move it. Upload and download binary data to or from SQL Server using standard tools
One day you make a decision to organize your collection - sort it, label it, tag it, remove duplicates and so on. The first thing you need - sophisticated data storage, of course. And it is obvious…
Today, We will go through with the steps of renaming or changing SQL Server Standalone Instance.
Step 1 : Check Current Instance & host name
Current Host Name : admin-0783e4076
Current SQL Instance Name : admin-0783e4076
Select @@ServerName ServerName, Host_name() HostName
Step 2 : Rename Host name & reboot the… Read more
0 comments, 353 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 29 June 2014
Been busy the past week, not as much time on this as I’d have liked:
- Received the “retro” flyer with the minor revisions we requested
- Decided flyers are final in design, just need to get them all into PDF
- Had our first weekly call and talked about the tempo for…
I am excited and humbled to be speaking at the PASS Summit for my second year in a row! There were 943 submissions and only 144 spots, so I am really excited and honored to be a part of the largest and most amazing SQL Server conference in the world.… Read more
Ever go digging through your backyard for dinosaur bones? Maybe not, but it’s worthwhile from time to time to dig out some old posts and find out if there are any undiscovered finds there. In this post, I’m bringing up some of my old posts to… Read more
Let’s make it democratic. Let’s ensure we get solid sessions from key people. And let’s save a ton of work in the process.
There are certain folks that are extremely knowledgeable in their areas of expertise. They also happen to be excellent presenters. Have the spotlight sessions and… Read more
There’s a brand new business intelligence conference launching next month in Denver, Colorado. The Mile High Tech Con is a three-day event taking place July 24-26, 2014, and is aimed at business intelligence practitioners, data analysts, and information managers/CIOs.
From the event website:
Featuring three days of sessions and events… Read more
On Facebook last night, I posted the following:
An operational DBA isn’t just a manager of a traditional RDBMS, transactional system. An operational DBA manages the data platform, whatever it is, when it hits production. Their goals are not traditionally the same as someone focused on development. They are looking…
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re not doing any real work anyway.
Posts That Were Popular This Week
- Dell Webinar: Subqueries For Superheroes
- Cheating DBCC To Fix Index Corruption
- Don’t Get Slimed By Bad Parameter Sniffing
Saturday June 14th 2014 seen the Christchurch, New Zealand SQL SERVER user group host its second SQL Saturday (#316).
We learnt a lot from running our first SQL Saturday back in August 2013 – which was SQL Saturday #252
For the second year in a row we hosted… Read more