SQL Server

SQL Server Community

SQL Server Blogs

Nakul Vachhrajani
Follow /25 Jan 2015 at 8:45pm / SQL Server

#0352 – SQL Server – Working with Temporary Tables (L100) – Scope

In this post, I provide a Level 100 primer on the scope related considerations for local temporary tables. While I have written about temporary tables a lot in the past (and the same has also been done by other writers), there are some questions that...
8 0 /
Jen Stirrup
Follow /24 Jan 2015 at 12:19am / SQL Server

Free PASS Business Analytics Conference webinars on 3rd Feb. Join our BA Marathon!

Free PASS Business Analytics training folks! PASS are holding a BA Marathon in the lead up to our Business Analytics conference in April in Santa Clara, CA. Top Business Analytics speakers free online event for our ‪#‎ PASSBAMarathon‬ include: Jen...
155 0 /
Jen McCown
Follow /23 Jan 2015 at 8:48pm / SQL Server

Video: A Better Way to Reindex

Sean presented A BETTER WAY TO REINDEX for the Performance Virtual Chapter. Here are links to the video, and to download the free Minion Reindex tool.
40 0 /
Tracy McKibben
Follow /23 Jan 2015 at 1:00pm / SQL Server

Friday Followup For January 23, 2015

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 Building (for FREE) a Virtual Server for SQL Demos...
42 0 /
NickyvV
Follow /23 Jan 2015 at 7:30am / SQL Server

NetFx3 Error While Installing SQL Server 2012 SP1 on Windows 8 VM

A while ago I was looking for a VM with SQL 2012 installed on it (and all the other BIDS and pieces :) because I was about to start learning for my MCSE and needed some serious SSAS training. Because I couldn't find one I decided to create one myself...
38 0 /
prashanthjayaram
Follow /22 Jan 2015 at 8:59pm / SQL Server

SQL- Querying XML attributes from XML Column

Read XML column attributes in to two columns DimType and Dimvalue  from the below example ‘<dimensions> <dimension name=”width”  value=”12.77″/> <dimension name=”height”  value=”0.14″...
49 0 /
Thomas LaRock
Follow /22 Jan 2015 at 6:39pm / SQL Server

Using Templates With SQL Server Management Studio

I love learning new things. I feel like a kid again at times, my eyes get wide as I imagine new possibilities using whatever things it is I have found. This is how I felt last week when I came across a feature of SQL Server Management Studio (SSMS) that...
57 0 /
Colleen Morrow
Follow /22 Jan 2015 at 3:00pm / SQL Server

Exam Prep 70-463: Data Flow Destination Adapters

This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012.  So far, we’ve covered: Tables and Schemas in the data warehouse Dimensions and...
60 0 /
Stuart Ainsworth
Follow /22 Jan 2015 at 12:29pm / SQL Server

New blog post on SQL Authority!

Very honored to be today’s guest blogger at Pinal Dave’s blog Journey to SQL Authority; check out my post here: http://blog.sqlauthority.com/2015/01/22/sql-server-the-dba-goes-to-mars-maintenance-architecture-research-and-support-notes-from...
426 0 /
Rohit Garg
Follow /22 Jan 2015 at 12:24pm / SQL Server

How to install standalone SQL Server 2012 instance ?

Steps to install standalone SQL Server 2012 instance 1) Start the setup > Go to Installation from Left > Click on 1st option of New SQL Server standalone edition from right 2) Click Ok to cont., In case of any failure, you need to fix that...
117 0 /
Kenneth Fisher
Follow /21 Jan 2015 at 1:00pm / SQL Server

Constraint names, Say NO to the default

Have you ever seen a constraint with a name like PK__TableNam__EA185FBF8FF1529D ? It’s kind of funny looking right? I mean it makes no difference in terms of how things run but it does make it a bit of a pain when you need to code with it. Say dropping...
62 0 /
Chris Webb
Follow /21 Jan 2015 at 12:04pm / SQL Server

Microsoft BI and SQL Server Courses For 2015

The Technitrain course schedule for 2015 has now been finalised, so if you’re looking for top quality Microsoft BI and SQL Server classroom-based training in central London why not check out what we’ve got coming up? Introduction to SQL Server Data...
66 0 /
regbac
Follow /20 Jan 2015 at 5:47pm / SQL Server

Speaking at SQL Konferenz 2015

In a few weeks I will be heading to Darmstadt (near Frankfurt) for speaking at the SQL Konferenz 2015 . This is my first time speaking at this event but from what I’ve heard from the previous y:ear this is a great event. The event is organised...
58 0 /
Basit A. Farooq
Follow /20 Jan 2015 at 5:17pm / SQL Server

Windows policy Lock Pages in Memory option and SQL Server instance in VM

As we know, this Windows policy  Lock Pages in Memory  option determines which accounts can use a process to keep data in physical memory, preventing the Windows operating system from paging out a significant amount of buffer pool pages from virtual memory...
71 0 /
Chris Webb
Follow /20 Jan 2015 at 5:11pm / SQL Server

Rendering Images In An Excel Worksheet With Power Query Using Cells As Pixels

It’s a general rule of the internet that, whenever you have a cool idea, a few minutes spent on your favourite search engine reveals that someone else has had the idea before you. In my case, when I first saw the functionality in Power Query for working...
138 0 /