SQL Server

SQL Server Community

SQL Server Blogs

James Serra
Follow /22 Jul 2014 at 4:00pm / SQL Server

SQL Server Agent job steps vs SSIS

When doing ETL , you have the choice of using T-SQL or SSIS  (see When to use T-SQL or SSIS for ETL ).  If you decide T-SQL is the way to go and you just want to execute a bunch of T-SQL statements (individually or within a stored procedure), it’s still...
3 0 /
Dinesh Asanka
Follow /22 Jul 2014 at 2:42pm / SQL Server

Difference Between LEN and DATALENGTH

DATALENGTH - Returns the number of bytes used to represent any expression. LEN - Returns the number of characters of the specified string expression, excluding trailing blanks Output is 30, 3. Important point to remember is is LEN function does not depend...
19 0 /
Chris Webb
Follow /22 Jul 2014 at 9:30am / SQL Server

Working With Excel Named Ranges In Power Query

One of the more recent additions to Power Query is the ability to access data from named ranges in the Excel worksheet rather than an Excel table. I’ve got used to formatting data as tables in Excel because that’s what Power Pivot needs to import data...
25 0 /
Melissa Coates
Follow /22 Jul 2014 at 12:35am / SQL Server

Where to Find Q&A Optimizations in Power BI

Just a quick tip about where to locate the options in Power BI for doing Q&A optimizations. In the Power BI site, these are not where you might first think to look. What is Q&A? First, just a quick bit on what Q&A is and why you should care...
29 0 /
Mike Davis
Follow /21 Jul 2014 at 9:51pm / SQL Server

Make an SSIS package Delay or Wait for Data

Packages can be scheduled to run at a time when you expect data to be in a database. Instead of guessing the time when the data will be in the database we can have the package look for data in a SQL table. When the table has data then the package will...
30 0 /
Jason Strate
Follow /21 Jul 2014 at 6:00pm / SQL Server

July 2014 – SQL Server Monthly Maintenance Checklist

image source It’s been a few months since I’ve updated my SQL Server monthly maintenance checklist.  Even though it hasn’t been updated, hopefully people have been continuing to look at their environments and performing the needed...
38 0 /
WaterOx
Follow /21 Jul 2014 at 4:17pm / SQL Server

Null Values in SQL Server

Walk & Talk #001 – Unknown or Null Values Ride with us in this video as we head to Richmond, Virginia to present to their user group. This is the first official Walk & Talk, but you’ll notice we’re not exactly walking along...
49 0 /
Jason Strate
Follow /21 Jul 2014 at 4:00pm / SQL Server

Last Weeks Top “Reading” Links #93

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...
42 0 /
Rohit Garg
Follow /21 Jul 2014 at 2:34pm / SQL Server

Steps to install Service Pack for SQL Server 2005 – Multiple Instances

Steps to install Service Pack for SQL Server 2005 on multiple instances in one go :- Step 1 : First page of Service pack setup. Informatory details only. Step 2 : Confirm EULA (End User License Agreement) to move ahead. Step 3 : Select instance...
31 0 /
Kenneth Fisher
Follow /21 Jul 2014 at 1:00pm / SQL Server

Add them to ALL the roles!

I seem to get a lot of permissions questions these days and one of the more frequent ones goes along these lines “I still don’t have the right permissions on database xyq.” So of course the first thing I do is use my handy dandy sp_dbpermissions...
42 0 /
Melissa Coates
Follow /19 Jul 2014 at 8:40pm / SQL Server

Creating a SharePoint Server Farm in Azure - Part 2

In Part 1 of Creating a SharePoint Server Farm in Azure , we went through the screen shots and steps available for using the gallery resources available in Azure for setting up a SharePoint Farm. In Part 2, we're going to look at the next steps to...
61 0 /
Josh Howard
Follow /18 Jul 2014 at 10:26pm / SQL Server

How to Accelerate SQL Queries and Reporting Across All Your Data

Join the Dell Software team on the 30th of July at 12:00 PM EDT for an informative webinar on How to Accelerate SQL Queries and Reporting Across Database Platforms. Register at https://software.dell.com/event/how-to-accelerate-sql-queries-and-reporting...
114 0 /
Jason Strate
Follow /18 Jul 2014 at 5:00pm / SQL Server

Reblog: July 11 to July 17

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...
67 0 /
Tracy McKibben
Follow /18 Jul 2014 at 1:00pm / SQL Server

Friday Followup For July 18, 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 Which One’s Better? Don’t Get Slimed...
51 0 /
Ricardo Leka
Follow /17 Jul 2014 at 9:56pm / SQL Server

Recuperar DML através do Transaction Log

Todos sabem que quando é feita uma operação no banco muita coisa passa pelo Transaction Log. Pode ser de minimamente logado ou até quase absolutamente tudo e todo mundo sabe que é possível restaurar muito do que foi feito através dos arquivos de backup...
60 0 /