SQL Server

SQL Server Community

SQL Server Blogs

Jason Strate
Follow /31 Oct 2014 at 4:00pm / SQL Server

Reblog: October 24 to October 30

Photo credit – Mike Lynch A good cure to a creepy doll is a good old post that is still useful. In this post, I’m going back over some of the posts that came out in this week in previous years. Having looked over these from time to time...
30 0 /
Follow /31 Oct 2014 at 2:00pm / SQL Server

Changing Your SQL Server Name

Is the name of your SQL Server correct? Why Worry About The Server Name In SQL? When the name of the actual host machine’s server name does not match the server name stored in SQL Server a lot of things can start to go wrong. Reporting services...
36 0 /
Colleen Morrow
Follow /31 Oct 2014 at 2:00pm / SQL Server

Summit and something new…

Let me just say, I’m excited. First of all, can you believe that the PASS Summit is next week?  Next. Week. Are you ready… to have your brain explode from all the SQL learnin’? to reconnect with your SQL Family? to add...
27 0 /
Tracy McKibben
Follow /31 Oct 2014 at 12:00pm / SQL Server

Friday Followup For October 31, 2014

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 Using Encryption To Protect Your Data From Alien...
29 0 /
Follow /30 Oct 2014 at 7:53pm / SQL Server

PASS Summit 2014 Is Right Around The Corner—Are You Ready To Be Social?

PASS Summit 2014 will be here before we know it! As you likely know, PASS Summit 2014 will be held November 4 to 7 in Seattle, Washington. It’s the world's largest and most intensive technical training conference for SQL Server and BI professionals...
48 0 /
Larry Leonard
Follow /30 Oct 2014 at 4:00pm / SQL Server

Two Simple Ways to Find Last SQL Server Restart

The first command below will tell you the last time the SQL Server service was started. The second will tell you the last time the server itself was restarted. -- Format will be: 2013-01-19 14:13:53.243 select sqlserver_start_time from sys.dm_os_sys_info...
93 0 /
Ashish Banga
Follow /30 Oct 2014 at 1:24pm / SQL Server

How to Configure Search in SharePoint 2013 || Configure Search Topology in SharePoint 2013

Hello Friends, I was getting lot of responses on blogs and mails. It will be difficult to cover all at once . So covering today the latest one “How to Configure Search in SharePoint 2013” and in Standalone server. Microsoft is focusing more and...
92 0 /
Follow /30 Oct 2014 at 12:00pm / SQL Server

Get Ready to Learn SQL Server: 17. How to use the Intersect Operator

All the examples for this lesson are based on Microsoft SQL Server Management Studio and the AdventureWorks2012 database.  You can get started using these free tools using my Guide  Getting Started Using SQL Server . How to use the Intersect Operator...
87 0 /
Follow /30 Oct 2014 at 11:49am / SQL Server

SQL Pass Summit 2014

Next week I will be in Seattle for the 2014 SQL Pass Summit event.  If you are involved in projects that leverage the Microsoft SQL Server stack this is a great conference to attend. If this is your first time going and would like some tips on making...
48 0 /
Derik Hammer
Follow /29 Oct 2014 at 12:00pm / SQL Server

Rebooting HRSSUG

This week I’m excited to announce the reboot of the Hampton Roads SQL Server User Group (HRSSUG). We will be coming back online this Novemeber, holding meetings every third Wednesday of the month. Check out our announcement below and be advised...
115 0 /
Kenneth Fisher
Follow /29 Oct 2014 at 12:00pm / SQL Server

Playing with the log – Before the first full backup

The log file tends to fascinate me. In fact one of my favorite posts is where I looked into the effect of VLF size on shrinking the log . So the other day I was asking about VLFs and got sent to this great video of a recorded session from PASS SQLRally...
43 0 /
Chris Webb
Follow /29 Oct 2014 at 10:24am / SQL Server

PASS Summit And Other Speaking And Training Dates

This is just a quick post to advertise some upcoming speaking and training dates… PASS Summit I’ll be at the PASS Summit in Seattle next week, and if you see me around be sure to say hello! I’ll be presenting a deep dive session on MDX scoped assignments...
50 0 /
Follow /28 Oct 2014 at 11:09pm / SQL Server

SQL Server – Failed to bring availability group ‘[availability group name]‘ online

Failed to bring availability group ‘[availability group name]‘ online. via Failed to bring availability group ‘[availability group name]‘ online.
52 0 /
Jason Brimhall
Follow /28 Oct 2014 at 7:25pm / SQL Server

Ghosts – an eXtrasensory Experience

This is the last article in a mini-series diving into the existence of ghosts and how to find them within your database. So far this has been a fun and rewarding dive into Elysium to see and chat with these entities.  We have unearthed some means to...
86 0 /
Jen McCown
Follow /28 Oct 2014 at 3:18pm / SQL Server

Session: Introduction to Powershell Cmdlets for DBAs

I’ve given my new Powershell Cmdlets for DBAs session a handful of times now, and just realized I haven’t blogged about it! Download the session recording here Download the code file here Abstract: You’ve been hearing about this newfangled...
78 0 /