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”

• SQLServer2005 Log Shipping question

  
  IT answers — Authority: 458
  New Question Created by Lorelei
  12 hours ago

• SQL Saturday #34/New England Data Camp v2.0

  
  Home of the Scary DBA — Authority: 126
  It’s official sports fans . Well, it’s been official since last week since Adam Machanic set up the web site. The New England SQL Server Users Group and the Southern New England SQL Server Users Group are again jointly hosting a full day of SQL Server goodness on January 30th. The call for sponsors and ...
  15 hours ago

• XQuery For Idiots

  
  Home of the Scary DBA — Authority: 126
  I’m still struggling with learning XQuery. My latest little revelation was small, but vital. The difference between: @inXML.nodes(/rss/channel/item) and @inXML.nodes(/rss[1]/channel[1]/item) Is the difference between a 10 minute query and a 4 second query. Kind of shocking really. My understanding is that ...
  20 hours ago

• Account delete...

  
  Programmers Heaven Forums RSS Feed — Authority: 163
  good day guys. i have an account, my login username is myname which happens to be one of the owner of a database in our sqlserver. i ask the netadmin to reset my password at first because my password is just blank and i can not change my password on my own pc. my computer os is windows xp sp3. sqlserver is MSSQL ...
  5 days ago

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

  
  stevienova.com — Authority: 104
  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 week ago

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

  
  Journey to SQL Authority with Pinal Dave — Authority: 539
  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 ...
  1 week ago

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

  
  Journey to SQL Authority with Pinal Dave — Authority: 539
  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 ...
  1 week ago

• Jamie Thomson’s whistlestop tour of SSIS addins

  
  Brent Ozar - SQL Server DBA — Authority: 527
  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 ...
  1 week ago

• Christian Bolton on SQL Server memory

  
  Brent Ozar - SQL Server DBA — Authority: 527
  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 ...
  1 week ago

• Donald Farmer #SQLBits keynote on PowerPivot

  
  Brent Ozar - SQL Server DBA — Authority: 527
  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 ...
  1 week ago

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

  
  Journey to SQL Authority with Pinal Dave — Authority: 539
  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 ...
  1 week ago

• Losing Weight and Testing Code

  
  Brent Ozar - SQL Server DBA — Authority: 527
  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. ...
  1 week ago

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

  
  Kingsley Idehen's Blog Data Space — Authority: 110
  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: 539
  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: 129
  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: 527
  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: 126
  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: 126
  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 ...
  2 weeks ago

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

  
  Journey to SQL Authority with Pinal Dave — Authority: 539
  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 ...
  2 weeks ago

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

  
  Visit SQLAuthority.com — Authority: 129
  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 ...
  2 weeks ago

Comments about sqlserver