SQL Server

SQL Server Community

SQL Server Blogs

SQLDBAPros
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...
30 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...
66 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...
78 0 /
sqlkris
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...
74 0 /
derekewilson
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...
35 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...
105 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...
38 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...
43 0 /
VSRaavi
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.
47 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...
49 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...
69 0 /
Chris Yates
Follow /28 Oct 2014 at 12:58pm / SQL Server

Im At Summit Now What?

Pass Summit 2011 – Photo Provided by Pat Wright We are a week out from PASS Summit 2014 and there will be many there attending for the first time. You are in the same boat I was in back in 2011. To be quite honest, I’ve never seen or attended...
50 0 /
Marlon Ribunal
Follow /28 Oct 2014 at 12:30pm / SQL Server

Getting back to basics

I committed to studying for MCSA SQL Server 2012 and taking the certification exams by the end of the year…last year. That didn’t happen. At the start of this year, I made that same commitment again. Neither did that happen. At that time,...
45 0 /
sqlkris
Follow /28 Oct 2014 at 1:23am / SQL Server

Learn to use Union, Intersect, and Except Clauses

Learn to use Union, Intersect, and Except Clauses The UNION , INTERSECT , and EXCEPT clauses are used to combine or exclude like rows from two or more tables.  They are useful when you need to combine the results from separate queries into one single...
159 0 /
Melissa Coates
Follow /28 Oct 2014 at 12:29am / SQL Server

When To Choose Analysis Services vs. Power Pivot?

The conversation about when to use SSAS vs. Power Pivot comes up a lot. Power Pivot is the data modeling component within the Power BI set of tools, and is suitable for certain self-service BI situations. Here's my top reasons when you may consider...
55 0 /