SqlServerKudos

DBA

1
kudos

Kudos

How to keep a track of list of SQL Server versions and builds releases?

published 8 days, 19 hours, 37 minutes ago posted by

sa 17 days, 20 hours, 7 minutes ago

How to keep a track of list of SQL Server versions and builds releases?

I believe until SQL Server 2000 (or even SQL 2005) it was easy to remember the release version of your SQL Server instance. Since the changes affected from SQL Server Release Services and inception of Cumulative Update packages it is hard to keep a track of list of builds and version releases. Let it be a controlled installation of service packs and cumulative update packages, you must know the information in order to check what is fixed in the release.In general the best practice is to apply only...(rea... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: blogger, cumulative update, database maintenance, DBA, release, service pack, SQL Server, Version

2
kudos

Kudos

Master SQL Chef series: Troubleshooting multi-server instances with #sql2k8r2cookbook

published 9 days, 19 hours, 42 minutes ago posted by

sa 18 days, 20 hours, 43 minutes ago

Master SQL Chef series: Troubleshooting multi-server instances with #sql2k8r2cookbook

Managing multiple instances of SQL Servers and databases is a challenging task, having a third party tool is not a problem however it is always BEST to manage the show using SQL Server Management Studio (SSMS). SQL Server tools are easy to use and help to manage multi-server management through automated multi-server jobs, event forwarding and the ability to manage multiple instances from a single-machine console. Since SQL Server 2008 R2 version (and SQL Server 2008 SP2) onwards the SSMS tool has...(read... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: #sql2k8r2cookbook, beginners, best practice, cookbook, data tier, DBA, management, SQL Server, SSMS, ucp, utility control point

1
kudos

Kudos

SQL Server Opertional practices: Support ended for SQL Server 2005 Service Pack 3 and its time to upgrade too!

published 22 days, 20 hours, 38 minutes ago posted by

sa 24 days, 21 hours, 8 minutes ago

SQL Server Opertional practices: Support ended for SQL Server 2005 Service Pack 3 and its time to upgrade too!

As of today the support for SQL Server 2005 Service Pack 3 ends, though the mainstream support for SQL Server 2005 was ended on 12th April 2011. This means only extended support is available for this version until 12th April 2016. Though there is a differnt set of support policy for service pack releases on every Microsoft product, which is nothing but support ends 12 months after next service pack releases or at the end of product's support lifecycle, whichever comes first. You can find more information... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: #sql2k8r2cookbook, administrator, Best Practices, DBA, lifecycle, sp_configure, sp3, SQL Server, support life cycle, Upgrade, upgrade advisor

1
kudos

Kudos

Super save promotion: Get 40% off on all e-books from Packt Publishers, grab it for world class SQL Server books

published 67 days, 23 hours, 50 minutes ago posted by

sa 73 days, 5 minutes ago

Super save promotion: Get 40% off on all e-books from Packt Publishers, grab it for world class SQL Server books

As a part of Super save promotion you have a golden choice to grab 40% discount straight on all e-books that are available from Packt Publishers . So browse through the library of eBooks and choose your favourite ones to get 40% off on the price, to get it enter the code APMD40 at 'Enter promotion code' field or click on 'Add promotion code' where the discount will be applied. Not to mention you can get my book too, titled: SQL Server 2008 R2 Administration cookbook and browse through list of books...(re... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: architects, beginners in sql serever, bes practice, books, code, cookbook, DBA, devloper, disaster recovery, ebook, packt, SQL Server

1
kudos

Kudos

SQL Server Days 2011 – Last Chance to Register

published 82 days, 51 minutes ago posted by

sa 88 days, 54 minutes ago

. SQL Server Days 2011 – Last Chance to Register One more week before the SQL Server Days. The team at SQLUG.be together with our partners and speakers are ready to deliver another spectacular edition. We have over 250 people registered so far, so don't hesitate and register now if you want to be part of this two-day event. Join us on 14/15 November 2011 at San Marco Village in Schelle to learn all about best practices for SQL Server 2008 R2 and all about the upcoming SQL Server 2012. With four tracks...... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: 2012, Conference, DBA, learning, mvp, new features, SQL Server, sqlug

1
kudos

Kudos

SQL Server performance series: PAGELATCH_ and PAGEIOLATCH_ wait types: relates to concurrency, take steps in diagnosing and resolving latch contention issues.

published 100 days, 3 hours, 39 minutes ago posted by

sa 109 days, 4 hours, 30 minutes ago

SQL Server performance series: PAGELATCH_ and PAGEIOLATCH_ wait types: relates to concurrency, take steps in diagnosing and resolving latch contention issues.

Contention is the word that you need to concentrate in resolving the performance issue, page latches contention is common in multi-CPU systems due to the nature of w hen multiple threads concurrently attempt to acquire incompatible latches to the same in-memory structure. Going back to basiscs a latch is an internal mechanism that is used by SQL DB engine automaticatlly to determine when to use it. By design they are deterministic and any behavior of schema design can affect the issue.One of the...(read ... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: buffers, cpu, DBA, dmvs, Memory, pageiolatch, perfmon, Performance, performance monitoring, SQL Server, tuning, wait stats

1
kudos

Kudos

SQL Server 2008 Service Pack 3 - SP3 is released, test and upgrade relevant instances

published 106 days, 4 hours, 5 minutes ago posted by

sa 115 days, 5 hours ago

SQL Server 2008 Service Pack 3 - SP3 is released, test and upgrade relevant instances

Well, its time now again for all DBAs and System Administrators out there to do some real-world testing on their SQL Server 2008 instance platform, service pack 3 for SQL Server 2008 is released now. If you are already testing the CTP version then its not a big issue to perform the test and upgrade the existing instances of 2008 version. Once you apply the SP3 for SQL Server 2008 the version will be 10.00.5500.00 and also the download page clearly states the key enhancements out this SP3 release:...(read... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: Best Practices, ctp, DBA, Documentation, download, Installation, service pack3, SQL Server

1
kudos

Kudos

Perform SQL Server Upgrade with the help of tools, best practices too #sqlbpa #upgrade

published 111 days, 4 hours, 25 minutes ago posted by

sa 120 days, 5 hours, 16 minutes ago

Perform SQL Server Upgrade with the help of tools, best practices too #sqlbpa #upgrade

SQL Server upgrade is no small task, no big task either when you have perfectly planned and tested the process! Since last 2 years the most popular topic and talk that I presented in various conferences, usergroup meetings and consulting projects is upgrade of SQL Server platform. Having said that for any task or process you need a trusted and proven set of commands, statements and tools irrespective of hardware configuration or support arrangements (ISV or Managed Services). Whenever I engage with...(re... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: beginners, best practice analyzer, Best Practices, database, DBA, download, SQL Server, Tools, upgrade advisor, upgrade assistant

1
kudos

Kudos

Book Review: Microsoft SQL Server 2008 R2 Master Data Services from Packt Publishers

published 116 days, 4 hours, 46 minutes ago posted by

sa 125 days, 5 hours, 41 minutes ago

Book Review: Microsoft SQL Server 2008 R2 Master Data Services from Packt Publishers

This is my first book review in this year, though it is a good experience in writing my first book on SQL Server technologies and here it goes: Book Title: Microsoft SQL Server 2008 R2 Master Data Services Publishers: Packt Publishers Master Data Services (MDS) is one of the new features that are introduced in SQL Server 2008 R2 version, and Master Data Management (MDM) concept which is also one of the new learning for me when I started working on data platform related projects. Whenever you start...(rea... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: beginners in sql serever, Best Practices, books, DBA, master data services, MDS, packt, review, SQL Server

1
kudos

Kudos

SafePeak's SQL Server performance contest - share your story get lucky to win!

published 119 days, 4 hours, 57 minutes ago posted by

sa 128 days, 5 hours, 56 minutes ago

SafePeak's SQL Server performance contest - share your story get lucky to win!

Its always good when you can mix your learning and knowledge in innovative way. My fellow MVP and good friend Robert Pearl (@pearlknows) referred few highlights and information about SafePeak's products. First things first, here is the exciting news for lucky folks our there who can share their story related to SQL Server performance and your personal experience in dealing/solving such problems at your work place. You can submit your story here and even share the news to your networking to get few...(rea... (more)

category: News | clicked: 1 | comment | | source: sqlserver-qa.net

tags: DBA, developers, mvp, Performance, performance monitoring, problem, safepeak, share, SQL Server

2
kudos

Kudos

MVP Deep Dives Volume II - SQL Server. Release n October 2011, get yours if are attending SQLPASS 2011 conference

published 128 days, 5 hours, 41 minutes ago posted by

sa 131 days, 6 hours, 10 minutes ago

MVP Deep Dives Volume II - SQL Server. Release n October 2011, get yours if are attending SQLPASS 2011 conference

Before I jump into details about this book, I'm glad to be part of this book and thanks to lead authors. SQL Server has evolved into a technology that offers multiple features raning from small data solution to the mission-critical enterprise soluion, no limit ... no boundaries. Likewise the community is managed by world-class professionals who share (endless) the experience with thier efforts such as blogging, writing articles, managing local usergroups and speaking at conferences. Similarly on...(read ... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: beginners in sql serever, Best Practices, BI, books, concepts, Conference, DBA, deep dives, developers, ebook, effective, mvp, performance monitoring, performance tunning, SQL Server, volume

1
kudos

Kudos

Improve the community with your knowledge and experience, lets join the wagon - T-SQL Tuesday #22 – Data Presentation

published 140 days, 6 hours, 35 minutes ago posted by

sa 150 days, 5 hours, 45 minutes ago

Improve the community with your knowledge and experience, lets join the wagon - T-SQL Tuesday #22 – Data Presentation

Ok, the holiday season is over and we can see the community is back in the track, no doubt that big conferences are lined-up across the globe. However the SQL Server community has become a global village with the help fo Twitter & blogging. I'm a regular follower of T-SQL Tuesdays flow that lets you full range of tips, tweaks and learning on a specific topic. Not only that you can be part of the event by posting a relevant topic with a twitter hashtag. My fellow MVP Robert Pearl has got a sum-up...(read ... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: benefits, Best Practices, community, DBA, devloper, hashtag, mvp, SQL Server, TSQL2sDay, tsql-tuesdays, tweet

1
kudos

Kudos

Take the offer on SQL Server 2008 R2 Administration cookbook and SQL Server 2008 R2 Master Data Services

published 141 days, 6 hours, 40 minutes ago posted by

sa 150 days, 6 hours, 50 minutes ago

Take the offer on SQL Server 2008 R2 Administration cookbook and SQL Server 2008 R2 Master Data Services

In continuation to the Packt Publishers September offer on Microsoft books I would like to promote two essential books to upgrade your knowledge in Microsoft SQL Server 2008 R2 technologies. Microsoft SQL Server 2008 R2 Administration Cookbook Over 70 practical recipes for administering a high-performance SQL Server 2008 R2 system with this book and eBook. Author: Satya Shyam K Jayanty Microsoft SQL Server 2008 R2 Master Data Services Authors: Jeremy Kashel , Tim Kent , Martyn Bullerwell Manage and...(re... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: beginners in sql serever, Best Practices, books, DBA, disaster recovery, ebook, master data services, offer, packt, Performance, performance monitoring, publisher, SQL Server

1
kudos

Kudos

SQL Server 2008 Service Pack 3 CTP is available for testing!

published 157 days, 8 hours, 26 minutes ago posted by

sa 164 days, 8 hours, 47 minutes ago

SQL Server 2008 Service Pack 3 CTP is available for testing!

There is no doubt that Microsoft is keeping the DBAs busy with the frequent releases of Cumulative Update packages and CTP releases on existing (2008, 2008 R2 and Denali) versions! Now here is the news about SQL Server 2008 Service Pack 3 CTP release from SQL Server Release Services team, this means there is no support offered from CSS and only the bugs can be reported via Microsoft SQL Server Connect website . the information is as follows: To download the CTP files click on this SQLServer2008SP3-CTP_KB... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: Bugs, cumulative update, DBA, download, rtm, server restart, service pack3, SQL Server, Testing, Version

1
kudos

Kudos

SQL Server Manageability series: Log files and Setup Bootstrap folder, the key elements to manage the data platform

published 173 days, 9 hours, 37 minutes ago posted by

sa 177 days, 7 hours, 37 minutes ago

SQL Server Manageability series: Log files and Setup Bootstrap folder, the key elements to manage the data platform

There a different types of log files available when you start to install the SQL Server and manage the instance. Whenever you talk about log file then immediate option is SQL Server error log file, which can be viewed from SQL Server Management Studio (SSMS) or as a text file from the operating system. Further the error logs are defined into SQL Server and operating system based, certain events/user-defined events/warning/errors are logged into these various log files. By default the events and informati... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: beginners, Best Practices, bootstrap, configuration, DBA, management, practices, setup, SQL Server

1
kudos

Kudos

SQLBits 9 - Query across the Mersey, Backup North! - High Availability and Disaster Recovery for the Novice DBA

published 174 days, 9 hours, 42 minutes ago posted by

sa 177 days, 9 hours, 47 minutes ago

SQLBits 9 - Query across the Mersey, Backup North! - High Availability and Disaster Recovery for the Novice DBA

I believe by this time most of you might have registered/noted your diaries with the dates about upcoming SQLBits 9 conference. If you haven't registered yet then, hurry-up - Registration is Now Open , like the previous events this is also a 3 day based conference. The format will be the now familiar 3 days of top SQL Server content given by SQL Server Experts from around the world, including Microsoft Certified Architects (MCA), Microsoft Certified Masters (MCM) and Microsoft Most Valued Professionals..... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: benefits, Best Practices, Conference, DBA, HA, high availability, SQL Server, SQLBits, usergroup

1
kudos

Kudos

SQL Server Managebility Series: Management Studio download with SQL 2008 R2 SP1 and few notes? #sql #tools

published 184 days, 10 hours, 29 minutes ago posted by

sa 192 days, 10 hours, 2 minutes ago

SQL Server Managebility Series: Management Studio download with SQL 2008 R2 SP1 and few notes? #sql #tools

In continuation to the SQL2K8R2 Service Pack1 post I got few emails asking why there are 2 additional files ( SQLManagementStudio_x64_ENU.exe & SQLManagementStudio_x86_ENU.exe) included in the SP1 download page. Few notes and gotchas about this SQL 2008 R2 SP1 release: This Service Pack1 is ONLY for SQL Server 2008 R2 instance, you CANNOT apply to a SQL Server 2008 instance. Service Pack 1 for SQL Server 2008 R2 does not include the MS11-049 security update QFE . For your personal purpose this...(read more) (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: Best Practices, DBA, Documentation, downgrade, download, Management Studio, SQL Server, Tools

1
kudos

Kudos

SQL Server 2008 R2 Service Pack1 available for download

published 185 days, 10 hours, 32 minutes ago posted by

sa 193 days, 9 hours ago

SQL Server 2008 R2 Service Pack1 available for download

SQL Server 2008 R2 service pack 1 is available for download now, after it was CTPd in the month of April 2011. The version number for this SQL2K8R2 SP1 will be: Microsoft SQL Server 2008 R2 (SP1) - 10.50.2500.0 As usual the Service Pack 1 files are availabel for the following editions and X86, X64 and IA64 environments: SQL Server 2008 R2 Datacenter Edition SQL Server 2008 R2 Enterprise Edition and Developer Edition SQL Server 2008 R2 Standard Edition SQL Server 2008 R2 Web Edition SQL Server 2008...(rea... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: ctp, DBA, Documentation, download, edition, serverproperty, sp1, SQL Server

1
kudos

Kudos

SQL Server BI: secure the Analysis Services instance and few best practice gotchas #sql #sqlBI

published 192 days, 11 hours, 7 minutes ago posted by

sa 199 days, 11 hours, 25 minutes ago

SQL Server BI: secure the Analysis Services instance and few best practice gotchas #sql #sqlBI

When it comes to security the Business Intelligence systems are also key parts of your data platform. In terms of securing SQL Server Analysis Services instance means there are certain Analysis Services configuration properties that you can set using the Management Studio. Similar to the core relational engine SQL Server 2008 Analysis Services also provide the deployment and configuration options that can be tailored based on each application security requirements. When it comes to Security the Policy-ba... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: Analysis Services, Best Practices, browser service, DBA, ebook, port, Security, service account, SQL Server, SSAS

1
kudos

Kudos

How to become a SQL Server DBA?

published 224 days, 13 hours, 20 minutes ago posted by

sa 233 days, 14 hours ago

Its a good question and I get to asked many times by the people who I meet and greet in Usergroup & Conference meetings. There is no clear or consice answer for this question, as it requires lot of patience and dedication to learn the concepts of the trade. To sum up all the key ingredients I recommend the excellent write up by John Sansom about How to Become a SQL Server DBA . Further if you're an experienced DBA (with atleast 3 years of experience) then I recommend the book titled: Microsoft...(read more) (more)

category: News | clicked: 2 | comment | | source: sqlserver-qa.net

tags: concepts, Conference, cookbook, DBA, learning, SQL Server

Welcome!

DBA

How to keep a track of list of SQL Server versions and builds releases?

Master SQL Chef series: Troubleshooting multi-server instances with #sql2k8r2cookbook

SQL Server Opertional practices: Support ended for SQL Server 2005 Service Pack 3 and its time to upgrade too!

Super save promotion: Get 40% off on all e-books from Packt Publishers, grab it for world class SQL Server books

SQL Server Days 2011 – Last Chance to Register

SQL Server performance series: PAGELATCH_ and PAGEIOLATCH_ wait types: relates to concurrency, take steps in diagnosing and resolving latch contention issues.

SQL Server 2008 Service Pack 3 - SP3 is released, test and upgrade relevant instances

Perform SQL Server Upgrade with the help of tools, best practices too #sqlbpa #upgrade

Book Review: Microsoft SQL Server 2008 R2 Master Data Services from Packt Publishers

SafePeak's SQL Server performance contest - share your story get lucky to win!

MVP Deep Dives Volume II - SQL Server. Release n October 2011, get yours if are attending SQLPASS 2011 conference

Improve the community with your knowledge and experience, lets join the wagon - T-SQL Tuesday #22 – Data Presentation

Take the offer on SQL Server 2008 R2 Administration cookbook and SQL Server 2008 R2 Master Data Services

SQL Server 2008 Service Pack 3 CTP is available for testing!

SQL Server Manageability series: Log files and Setup Bootstrap folder, the key elements to manage the data platform

SQLBits 9 - Query across the Mersey, Backup North! - High Availability and Disaster Recovery for the Novice DBA

SQL Server Managebility Series: Management Studio download with SQL 2008 R2 SP1 and few notes? #sql #tools

SQL Server 2008 R2 Service Pack1 available for download

SQL Server BI: secure the Analysis Services instance and few best practice gotchas #sql #sqlBI

How to become a SQL Server DBA?

Open ID Login

Standard Login

Forgot Password?

Sign up