Latest Blog Posts
I’m writing this blog post to simply to vent some frustration. I live in Wales’ third largest city, Newport and for some obscure unbelievable reason I am unable to get high speed internet. BT’s online speed check currently tells me the very best I can hope for is…
I never… Read more
I’ve always been a fan of the feeling when I find an old blog post that’s got just the information that I need to solve a problem or answer a question. It’s that whole “cha-ching” – buried treasure! feeling. That’s kind of the aim of this blog post. To provide… Read more
This will be my fifth speaker of the month post. Do a search to see the others.
I try to find speakers that people may not have heard of who are out there, working hard, doing a good job. But, sometimes, I’m going to see a presentation by someone who… Read more
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
- So, This Happened Today…
- Automated Permissions Auditing With Powershell and T-SQL: Part 1
- Do You Need A Log…
It’s time for another free webinar!!
Whether you like it or not SharePoint is here to stay! With every release of SQL Server or SharePoint (which follow different release cycles) the feature set for Business Intelligence professionals gets more fragmented and more complicated. If I want to get Feature A… Read more
Start testing theories at home. you can install VirtualBox and get a SQL instance up and running off trials.
Watch the forums, see the…
Tablediff is a command line utility that comes with SQL Server to compare the data and schema in two tables for differences and generate a T-SQL script to synchronize them. It's a rudimentary but useful tool that most people don't know is available and it gets the job done when… Read more
Today I have uploaded the 8th SQL Server Quickie to YouTube. This time I’m talking about Hash Indexes in SQL Server 2014. You can find the script used during the demonstration here as a download.
Thanks for watching!
As I mentioned in my previous post (see Power BI first impressions), Power Query is a great new tool and Microsoft has been updating it frequently. The latest update has many new features, among them:
- Connectivity to Windows Azure Table Storage – You can now import from Windows Azure…
Today at 3 pm EST I’m presenting Surviving The First Week As The New DBA. Some of the topics I’m going to discuss are:
- About the goals you should set for your first week on a new job as a DBA
- Why backups & free space are the most…
Come get your learn on with Pragmatic Works and myself! In January I’ll be dropping some knowledge about change data capture and how to consume it with SSIS. CDC is one of the features I wish more of my clients were leveraging. It makes doing incremental loads dramatically more simplified.… Read more
First, what's blocking?
0 comments, 66 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 5 December 2013
Join SQL Server professionals from around the world for free online technical training and networking year round. PASS Virtual Chapters (VC) are interest-based forums that unite the SQL Server community through live webcasts with top SQL Server experts, online forums and resources – including an archive of past presentations,… Read more
PASS SQL Saturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. Please note that in order to attend one of these event, you must register (registration links are provided for each event). Please register soon as seating is limited, and let… Read more
A while back I talked about the DEFAULT keyword and using it to tell SQL to use the default value without having to specify an actual value. Well along that same note, what do you do if you want all of the columns to use their defaults? Or if you… Read more
All ColoradoSQL user group meetings start at 5:30 p.m. and provide food and refreshments. There is no cost to attend so bring a co-worker…or two. These events provide for great learning opportunities, as well as networking with other local SQL Server professionals. Some groups are not holding a regular… Read more
I got a request to monitor multiple services and send an email to intended recipients. This post explains how to monitor a multiple services on a group of servers. The function Get-ServiceStatusReport comprises of various cmdLets and function to monitor services on a list of servers.
- HTML Ouptut
Digging Around In Google Code
Google Code was very thin when it comes to SQL Server. I did find a few of interesting projects that may appeal to others as well as me. I will say there was a TON of use SQL Server with x programming language.
Microsoft publishes the following caution about enabling the CredSSP Windows Group Policy:
Caution: Credential Security Support Provider (CredSSP) authentication, in which the user’s credentials are passed to a remote computer to be authenticated, is designed for commands that require authentication on more than one resource, such as accessing a remote… Read more