SQL Server

Tag details

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'.

Look up Offsite Link "SQL", Offsite Link "Server" at The Free Dictionary

Latest blogosphere posts tagged “SQL Server”

  • Powershell script to find orphan stored procedures


    Richard DingwallAuthority 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 PerformanceAuthority 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


    SQLServerPediaAuthority 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


    SQLServerPediaAuthority 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 answersAuthority Authority: 458
    New Discussion Post by CraigN
    6 hours ago
  • SQL Server 2008 R2 Enterprise Evaluation November Download


    Bink.nuAuthority 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 MicrosoftAuthority 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.


    SQLServerPediaAuthority 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


    SQLServerPediaAuthority 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


    SQLServerPediaAuthority 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”


    SQLServerPediaAuthority 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…


    SQLServerPediaAuthority 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 RDBMSAuthority 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


    SQLServerPediaAuthority 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 DBAAuthority 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.


    SQLServerPediaAuthority 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 answersAuthority 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 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?


    SQLServerPediaAuthority 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 DaveAuthority 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

Personal attacks are NOT allowed
Please read our comment policy