SQLServer

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

Latest blogosphere posts tagged “SQLServer”

• SQL Server Schema Automatic Revision History using DDL Triggers and SVN

  
  stevienova.com — Authority: 100
  SQL 2005 introduced DDL Triggers, where you could catch events on your DDL statements in SQL, and hopefully most DBA’s are catching them, at least to a table and have some kind of report on who is adding, changing and deleting what objects. What I wanted to do was capture that, but also keep and automatic running ...
  1 day ago

• SQL SERVER – A Common Design Problem – Should the Primary Key Always be a Clustered Index

  
  Journey to SQL Authority with Pinal Dave — Authority: 529
  In SQL Server, whenever we create any key, a Primary Key automatically creates clustered index on the same. I like this feature and I use this feature every now and then. The question is does the change of any column as Primary Key should also create a Clustered Index? Moreover, is there any case, where one would not ...
  2 days ago

• SQL SERVER – Remove Bookmark Key Lookup – 4 Different Ideas

  
  Journey to SQL Authority with Pinal Dave — Authority: 529
  I quite often get request to summarized my ideas about Removing bookmark lookup on this blog post. Bookmark lookup or key lookup are bad for any query as they force query engine to lookpup corresponding row in the table or index as it does not find required data from just reading the data. Here are list of my four ...
  3 days ago

• Jamie Thomson’s whistlestop tour of SSIS addins

  
  Brent Ozar - SQL Server DBA — Authority: 530
  At #SQLbits , Jamie Thomson (Blog – Twitter) demoed the following SSIS add-ins: Kimball SDC Trace File Source XMLify File Watcher Dynamic Data Flow Rank Transform Normaliser Twitter Compression XMLify Jamie find this useful when parsing error output from other SSIS steps, which often have several ...
  4 days ago

• Christian Bolton on SQL Server memory

  
  Brent Ozar - SQL Server DBA — Authority: 530
  At # SQLBits , I was quite excited to attend this session because of the presenter.  Christian Bolton of COEO ( Blog – Twitter ) was the head author on our upcoming book SQL Server 2008 Internals and Troubleshooting , and he’s one of the only 8 Microsoft Certified Masters on SQL Server that work outside of ...
  5 days ago

• Donald Farmer #SQLBits keynote on PowerPivot

  
  Brent Ozar - SQL Server DBA — Authority: 530
  Donald Farmer ( @DonaldDotFarmer ) talked about IT in terms of data, and did it with an interesting picture story from the early 20th century.  Data today isn’t all that different from the messy desktops and clean library card catalogs of the last century. Donald Farmer onstage at SQLbits IT professionals ...
  5 days ago

• SQLAuthority News – Book Review – Expert SQL Server 2008 Encryption by Michael Coles

  
  Journey to SQL Authority with Pinal Dave — Authority: 529
  Expert SQL Server 2008 Encryption (Paperback) Michael Coles (Author), Rodney Landrum (Author) Link to Amazon “What is your opinion on encryption? What I mean is: In a world filled with data, how do you see encryption?” This is the precise question Michael Coles posed to me on March 3 rd of this ...
  5 days ago

• Losing Weight and Testing Code

  
  Brent Ozar - SQL Server DBA — Authority: 530
  David Stein ( Blog – Twitter ) wrote a post called “ Pop Quiz Hotshot ” about starting your disaster recovery plan *now*.  It’s a great read with good points that everyone needs to act on, but the comments indicate that not everybody’s seeing eye to eye.  As usual, I rely on similes because I’m lazy. ...
  6 days ago

• Five Game Changing Things about the OpenLink Virtuoso + AWS Cloud Combo

  
  Kingsley Idehen's Blog Data Space — Authority: 107
  Here are 5 powerful benefits you can immediately derive from the combination of Virtuoso and Amazons AWS services (specifically the EC2 and EBS components): Acquire your own personal or service specific data space in the Cloud. Think DBase, Paradox, FoxPRO, Access of yore, but with the power of Oracle , ...
  1 week ago

• SQL SERVER – Size of Index Table – A Puzzle to Find Index Size for Each Index on Table

  
  Journey to SQL Authority with Pinal Dave — Authority: 529
  It is very easy to find out some basic details of any table using the following Stored Procedure. USE AdventureWorks GO EXEC sp_spaceused [HumanResources.Shift] GO Above query will return following resultset The above SP provides basic details such as rows, data size in table, and Index size of all ...
  1 week ago

• SQL SERVER – Size of Index Table – A Puzzle to Find Index Size for Each Index on Table

  
  Visit SQLAuthority.com — Authority: 127
  It is very easy to find out some basic details of any table using the following Stored Procedure. USE AdventureWorks GO EXEC sp_spaceused [HumanResources.Shift] GO Above query will return following resultset The above SP provides basic details such as rows, data size in table, and Index size of ...
  1 week ago

• Our Upcoming Book Cover

  
  Brent Ozar - SQL Server DBA — Authority: 530
  Now this is just plain liquid awesome: My Book Cover Beats Your Book Cover When WROX decided to dump the author photos on the book covers, I was bummed out.  One of the big selling points of a book is to have your name on it, to point to it in the bookstore and say, “I made that.”  Having the authors on ...
  1 week ago

• Record of a PSS Call

  
  Home of the Scary DBA — Authority: 127
  Not everyone has the opportunity to call Microsoft Premier Support. For those who have not yet had this experience, I’ll document my most recent, non-critical, call. Critical calls are a different critter entirely. We were experiencing a very odd error on one server in our system. When a particular procedure was ...
  1 week ago

• Dev Connections Recap

  
  Home of the Scary DBA — Authority: 127
  Last week I attended the Dev Connections conference for the first time. It was held in the Mandalay Bay resort in Las Vegas. The conference is different because it doesn’t concentrate on any one technology, but combines a bunch of them; ASP, Sharepoint, SQL Server, Visual Studio & Architects. That makes it a ...
  1 week ago

• SQLAuthority News – Notes of Excellent Experience at SQL PASS 2009 Summit, Seattle

  
  Journey to SQL Authority with Pinal Dave — Authority: 529
  Update: Do not forget to checkout last three photos and follow me on twitter (of course!) I have previously documented my four-day experience of SQL PASS 2009 Summit at Seattle. There were many reasons for SQL enthusiasts to attend the SQL PASS event; I am listing my own reasons here in order of importance ...
  1 week ago

• SQLAuthority News – Notes of Excellent Experience at SQL PASS 2009 Summit, Seattle

  
  Visit SQLAuthority.com — Authority: 127
  Update: Do not forget to checkout last three photos and follow me on twitter (of course!) I have previously documented my four-day experience of SQL PASS 2009 Summit at Seattle. There were many reasons for SQL enthusiasts to attend the SQL PASS event; I am listing my own reasons here in order of importance ...
  1 week ago

• Help With SQL Triggers!!

  
  Programmers Heaven Forums RSS Feed — Authority: 163
  This is what I had to do for my assigment!! I am just checking if this is correct!! Any help would be nice!! Thank You in Advance! Create and test the following triggers for the database created in Programming Assignment 6. 1. A trigger that prevents the number of miles on a truck from being decreased. This what I ...
  1 week ago

• SQL Server Agent – Query To Find Long Running Jobs

  
  stevienova.com — Authority: 100
  I use SQL Agent a ton. It is like my go to place to schedule jobs and tasks. Problem is, there are pieces “missing”. Like if a job hangs, you can have it auto stop after a given amount of time. It doesn’t alert on changes to a job, etc, etc. I asked on twitter what the DBA’s think, @SQLRockstar thinks using ...
  1 week ago

• SSAS: Errors in the metadata manager. The dimension with ID of…

  
  stevienova.com — Authority: 100
  Crazy error today. In Analysis Services, (SSAS), some jobs got hung, sync command got hung, and what ended up happening is a cube on the default instance was totally unusable. Try to delete, rename, resync, redeploy, anything, and I would get the error.. Errors in the metadata manager. The dimension with ID of.. ...
  1 week ago

• A Comparison of SQL Server Pricing Through the Years

  
  TechUrbia — Authority: 112
  Recently Microsoft announced the new SQL Server 2008 R2 pricing and a lot of people wondered, "Why such big price increases?" There are the new "premium" editions - Datacenter and Parallel Data Warehouse - which are priced at more than $50,000 per processor but what caught my eye is the increase in both the Standard ...
  1 week ago

Comments about SQLServer