Looks like we’ll have another service pack to install before going to SQL Server 2012 – check out the latest skinny from the engine boyz on the new service pack. Perusing the bug fix list, I don’t see a great deal that I’m foaming over, but there are a couple of things that are noteworthy. For insta... [More]

Posted in: SQL Server 2008/R2  Tags:
The description in performance monitor given: Number of scans per second that were initiated to search for free space within pages already allocated to an allocation unit to insert or modify record fragments. Each scan may find multiple pages. Microsoft RAP expands the definition: Inserts ... [More]

Posted in: SQL Server Performance  Tags:
lee posted on May 10, 2012 09:45
I just happened to catch some photos of the ongoing SQLRally in Dallas Texas (it’s today and tomorrow at the Dallas Convention Center…no I’m not speaking or attending), and I’m prompted to ask the question…”Are DBAs as an IT group an unhealthy bunch?”  I was sort of surprised to see, as each pi... [More]

Posted in: Etc. (Off-topic)  Tags:
Amazon has added Microsoft SQL Server 2008R2 to its cloud offering with SQL Server 2012 on the way; check out the full write-up on the Amazon RDS page for the breakdown, including levels of service, bring your own license (BYOL) plans, and features, editions, and pricing.  Seems like they have ... [More]

Posted in: SQL Server 2008/R2 , SQL Server 2012  Tags:
When running the RedGate suite of products, in my case SQL Compare, you might get the following message flooding your SQL Server logs each time you do a schema compare: DBCC TRACEON 3604, server process ID (SPID) 90. This is an informational message only; no user action is required. I’ve ... [More]

Posted in: SQL Administration  Tags:
I just got the following error this morning – filtering for it, I verified that I haven’t seen it prior to today: TCP connection closed but a child process of SQL Server may be holding a duplicate of the connection's socket.  Consider enabling the TcpAbortiveClose SQL Server registry settin... [More]

Posted in: SQL Server 2008/R2  Tags:
For this week’s “Best of”, here’s a super duper post on installing SQL Server 2012 from the command line. Follow his instructions to get up and running easily. On a sidebar, I’ve noticed that it’s very quiet these days on their blog site. I sort of find this puzzling, seeing that a brand-new produc... [More]

Posted in: The Best of MSDN Blogs  Tags:
Lee posted on April 27, 2012 14:04
A popular thing to do in SSIS for solving recurring problems is to create “patterns”; a certain degree of creativity is necessary in Microsoft SQL Server Integration Services because we don’t have all of the fancy transformations that some of the other super-expensive ETL tools hav... [More]

Posted in: SSIS  Tags:
Once a year I take a peek at my web stats on Google Analytics to see who is looking at what on my blog.  I jot these down in a list by rank because I’m just curious more than anything - most of these posts are either things that I run into while working as a database guy each day, or issu... [More]

Posted in: Etc. (Off-topic)  Tags:
lee posted on April 23, 2012 08:27
The XOR swap algorithm (exchanging values in two variables without the assistance of a third “temporary” variable) works in TSQL in addition to other programming languages as you might expect; why you would want to do it, well, you’d be hard-pressed to find the reason in our set based world. Matter ... [More]

Posted in: TSQL , Etc. (Off-topic)  Tags:
Yesterday I found an interesting blog posted by MSDN and the Visual Studio & TFS for US Public Sector folks regarding MSDN subscriptions. Not sure when this rule was changed, or maybe I never heard of it, but with an MSDN subscription “you may access/use any Microsoft Enterprise product fo... [More]

Posted in: The Best of MSDN Blogs  Tags:
So you wanna be a SQL star? Maybe become a SQL Server MVP? Gain notoriety, maybe someday work for Microsoft or Paul Randal over at SQL Skills? Write books, articles, and fly all over the country as a SQL Evangelist? First place to start I reckon is to get on the speaker list for SQL Pass (Profession... [More]

Posted in: CTP  Tags:
At some point between the Fall 2005 (SQL 2005 release) and now, Microsoft removed the functionality where you can restore multiple transaction log (tlog) files inside of SQL Server Management Studio. This is fine that you can still do it in TSQL, but if you have 15+ log files to restore, it’s kind o... [More]

Posted in: SQL Administration  Tags:
lee posted on April 12, 2012 09:26
As a reminder, the set of AdventureWorks databases for SQL Server 2012 were released last month, with an update to the downloads yesterday. You can find those here.  It looks like they’ve done things differently this time around, with both data file downloads as well as scripts. I downloaded th... [More]

Posted in: SQL Server 2012  Tags:
Lee posted on April 11, 2012 20:19
At the Microsoft download site, a recent link for a SQL Azure Federation poster that describes the following was added: The poster explains the federation process, including creating the federation root database, creating the scheme, and then using the split operation to partition the federation ... [More]

Posted in:   Tags:
A few things that I wanted to share, a really good blog that I ran into yesterday, the US ISV Evangelism team member Bruce Kyle posted a “Getting Acquainted with NoSQL on Windows Azure” that I recommend. If you have not read up on NoSQL and MongoDB in particular, I think you’ll find this to be an ex... [More]

Posted in: The Best of MSDN Blogs  Tags:
lee posted on April 3, 2012 18:47
TechNet has links to the most current SQL Server Samples, including the AdventureWorks 2012 data files as well  as samples that cover SQL Server, Analysis Services (both multidimensional and tablular), Reporting Services, Power View, and PowerPivot for Excel. Here’s their excerpt: The SQL S... [More]

Posted in: SQL Server 2012  Tags:

by Lee Everest, M.S.

Info

Poll

Do you use Azure or cloud in your organization?
Show Results

Ads

Search


Month List

Calendar

«  May 2012  »
MoTuWeThFrSaSu
30123456
78910111213
14151617181920
21222324252627
28293031123
45678910
View posts in large calendar

Tags

Disclaimer
The opinions, code, examples, et.al. expressed herein are my own personal opinions and do not represent my employer's view in any way, shape form, or fashion.  All code for demonstration purposes - no guarantees, either written or implied, are made.

© Copyright 2012 Lee Everest's SQL Server, etc. weblog