SQL Server

Welcome to the 'SQL Server' tag page at Technorati. This page features content from the farthest reaches of the Blogosphere that authors have "tagged" with 'SQL Server'.

Latest blogosphere posts tagged “SQL Server”

• Powershell script to find orphan stored procedures

  
  Richard Dingwall — Authority: 456
  Working on a legacy application that uses over 2,200 stored procedures, it can be hard to keep track of which ones are still active and which can be deleted. Here’s a quick PowerShell script I wrote that locates stored procedures in a database that aren’t referenced by code or other database objects (assuming you ...
  1 hour ago

• SQL Server 2005 Diagnostic Information Queries

  
  Glenn Berry's SQL Server Performance — Authority: 121
  Here is an updated version of my diagnostic information queries for SQL Server 2005. You can get the SQL Server 2008 version here . Most of the DMV queries require VIEW SERVER STATE permission. -- SQL Server 2005 Diagnostic Information Queries-- Glenn Berry -- November 2009-- ...
  4 hours ago

• Looking Back – PASS Summit 2009 Day 1

  
  SQLServerPedia — Authority: 145
  I intended to blog daily while at the PASS Summit last week. At least thats what I told myself I was going to do beforehand, then I realized that wasnt possible once I got there…at least not with the schedule I kept. This was my first time at the summit and after the first day I understood everything I had ...
  5 hours ago

• Looking forward, with renewed enthusiasm

  
  SQLServerPedia — Authority: 145
  With SQL PASS Summit 2009 now over, it’s time to return to the real world. Fortunately I booked a few extra days off; it’s time needed to recover from the cold I picked up in Seattle and gather my thoughts about all of the things I learned and people I met in the past week. The five days were a flurry of ...
  6 hours ago

• SQL select for month date range

  
  IT answers — Authority: 458
  New Discussion Post by CraigN
  6 hours ago

• SQL Server 2008 R2 Enterprise Evaluation November Download

  
  Bink.nu — Authority: 578
  SQL Server 2008 R2 November CTP has numerous new and enhanced features. This document provides the information you need to fully take advantage of these features. For Analysis Services, numerous enhancements have been added to the PowerPivot field list. These include automatic relationship detection when columns ...
  6 hours ago

• Which should a small business choose: Windows Home Server or Windows Server Foundation?

  
  All about Microsoft — Authority: 654
  Until quite recently, Microsoft officials emphasized the "home" in Windows Home Server (WHS) when explaining how that product fit into its server line-up. Last week, however, something changed. Microsoft officials added small office/home office (SOHO) users to its list of potential customers for WHS.
  7 hours ago

• Didn’t attend SQL PASS? Twitter was the next best thing.

  
  SQLServerPedia — Authority: 145
  I didn’t attend the 2009 SQL PASS Summit in Seattle  but I am following a bunch of people on Twitter who did. There tweeting and twitpics were the next best thing.  The Twitter feed was like a stock ticker that kept me current on what was happening at SQL PASS. What did I learn via Twitter regarding SQL ...
  10 hours ago

• Thrive

  
  SQLServerPedia — Authority: 145
  Apparently, I am the IT Pro of the Month for Microsoft Thrive : https://www.microsoft.com/click/thrive/default.aspx That, along with $2, will buy you a cup of coffee in most places, providing you do NOT forget the $2. If you are not familiar with Thrive then I urge you to navigate the site and check on the ...
  11 hours ago

• SSIS Expressions Cheatsheet

  
  SQLServerPedia — Authority: 145
  Maybe you’re new to SSIS, like I am, or maybe you just need a little refresher on expressions in SSIS. I just ran across the SSIS Expressions Cheatsheet . This is a page on the PragmaticWorks website. It’s also available as a downloadable .pdf file. For me, anyway, it’s a great one-page reference. I’ve got ...
  12 hours ago

• Safety IS spelled with an “E”

  
  SQLServerPedia — Authority: 145
  This is going to be another “I love PASS and had a great time at the Summit” post so hopefully you’re not tired of reading those yet. So as most of you know this was my first Summit experience and I can’t say enough great things about it… it was probably the most busy week of my life and sleep just seemed ...
  13 hours ago

• Hi, Eric Stratton, Rush chairman…

  
  SQLServerPedia — Authority: 145
  A few times this past week I heard the quote, “Hi, Eric Stratton, Rush chairman, damn glad to meet you”.  That line kind of summarizes what the PASS Summit was like for me this year.  It’s been like coming to a week long rush event for the best fraternity in the world.  This fraternity isn’t the Delta Tau ...
  14 hours ago

• Minimally logged and the recovery model

  
  Systems Engineering and RDBMS — Authority: 108
  Yesterday, while attending a conference call related to a production issue at a client site, we had to emphasize to the client DBA one of the concepts related to minimally logged operation.  It is well documented, however people tend to miss this information. In SQL Server, there are several minimally logged ...
  15 hours ago

• The King of Bedside Manor

  
  SQLServerPedia — Authority: 145
  Database administrators, like doctors, have to break some ugly news.  We have to tell developers that their code won’t scale, tell project managers that they didn’t buy enough hardware, and tell CFOs that we’ve actually got about three times as many servers as we’re licensed for. Hamster? I Hardly Know ...
  15 hours ago

• The King of Bedside Manor

  
  Brent Ozar - SQL Server DBA — Authority: 530
  Database administrators, like doctors, have to break some ugly news.  We have to tell developers that their code won’t scale, tell project managers that they didn’t buy enough hardware, and tell CFOs that we’ve actually got about three times as many servers as we’re licensed for. Hamster? I Hardly Know ...
  15 hours ago

• #sqlpass is over. Some thought, comments, and reviews.

  
  SQLServerPedia — Authority: 145
  The 2009 SQL PASS Summit has ended.  Our friends and extended family have made there way home, or are on there way home.  As I sit in the airport on Saturday on my way home to Southern California it seams like a good time to put down some thoughts about this years PASS Summit. I posted some blog posts about the ...
  17 hours ago

• SQl Server Replication Internals

  
  IT answers — Authority: 458
  New Question Created by Shahi
  23 hours ago

• Fix for ‘The database principal owns a schema in the database, and cannot be dropped’ Error in SQL Server 2005

  
  Microsoft Technology, .Net, BizTalk, Sharepoint & etc. — Authority: 120
  It happens when you are trying to delete a SQL user. To change the DB_Owner to some another “Database Principal”; simply Drill Down to your Database in Sql Server Management Studio and further more Drill Down to your_DB_Name >Security > Schemas > db_owner > right click > select properties. You would ...
  1 day ago

• Seacoast SQL Server Users?

  
  SQLServerPedia — Authority: 145
  Live in NH, Maine or Northern Mass? I have been toying with the idea in the back of my head to get a user group setup for SQL Server folks a little closer to home. I love the New England SQL Server users group ( NESQL ) that Adam Machanic ( twitter , blog ) runs. I have been to several meetings and the speaker list ...
  1 day ago

• SQL SERVER – Removing Key Lookup – Seek Predicate – Predicate – An Interesting Observation Related to Datatypes

  
  Journey to SQL Authority with Pinal Dave — Authority: 530
  Recently, I have been working on Query Optimization project. While working on it, I found the following interesting observation. This entire concept may appear very simple, but if you are working in the area of query optimization and server tuning, you will find such useful hints. Before we start, let us understand ...
  1 day ago

Comments about SQL Server