SqlServerKudos

DBA

1
kudos

Kudos

SQL Server 2008 Best Practices Analyzer - keep an eye for the release

published 735 days, 2 hours, 21 minutes ago posted by

sa 744 days, 4 hours, 45 minutes ago

SQL Server 2008 Best Practices Analyzer - keep an eye for the release

What practice do you classify as a best practice? The answer is its not a rocket science, you don't need any specific formula to satisfy the need! Ok what if a tool can follow those common best practices & perform an alerting mechanism that can help DBAs to keep the data platform secure & safe according to industry best practices. Not only that even DBAs need to perform a tweaking practices on SQL Server platform manually to find it as ideal configuration. SQL Server Best Practices Analyzer...(read more) (more)

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

tags: beginner, Best Practices, bpa, DBA, Documentation, SQL Server, sqlbpa, Tools, versioncontrol

1
kudos

Kudos

SQL Server in Virtual platform - keep a close watch on physical server's configuration

published 743 days, 2 hours, 55 minutes ago posted by

sa 752 days, 5 hours, 31 minutes ago

SQL Server in Virtual platform - keep a close watch on physical server's configuration

Server consolidation & virtualization is a hot topic and also it is one of the biggest concerns for many DBAs is scalability/performance when it comes to virtualization. At this point,performance for virtual machines can be close to, if not the same as, many physical server configurations. Just not in case if you have multiple SQL instances, its fuel to problem. Also the DBAs cannot ignore the fact that Virtualization is advantageous for the company and consolidation gets flexibility to manage...(read more) (more)

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

tags: Best Practices, configuration, cpu, DBA, disk, hyper-v, i/o, Memory, partition, Performance, SQL Server, virtual

1
kudos

Kudos

SQL Server detected a logical consistency-based I/O error: Error 824, take help of trace flags and event notifications

published 750 days, 3 hours, 26 minutes ago posted by

sa 759 days, 4 hours ago

SQL Server detected a logical consistency-based I/O error: Error 824, take help of trace flags and event notifications

This is a every DBA's nightmare to see if they have been alerted, yet another IO related post I would like to talk on explanation & resolution. Error 824 error indicates that a logical consistency error was detected during a read. A logical consistency error is a clear indication of actual damage and frequently indicates data corruption caused by a faulty I/O subsystem component. This is a pure indication about the hardware inconsistency within the environment with a serious I/O subsystem stability...(re... (more)

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

tags: beginner, Best Practices, DBA, dbcc checkdb, error log, extended, Monitoring, Performance, reads, recovery, search, SQL Server, torn page

1
kudos

Kudos

SQL Server Management Data Warehouse - quick tour on setting health monitoring policies

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

sa 777 days, 2 hours, 11 minutes ago

SQL Server Management Data Warehouse - quick tour on setting health monitoring policies

Profiler, Perfmon, DMVs & scripts are legendary tools for a DBA to monitor the SQL arena. In line with these tools SQL Server 2008 throws a powerful stream with policy based management (PBM) framework & management data warehouse (MDW) methods, which is a relational database that contains the data that is collected from a server that is a data collection target. This data is used to generate the reports for the System Data collection sets, and can also be used to create custom reports. All...(read more) (more)

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

tags: Best Practices, DBA, edition, executesql, management data warehouse, mdw, Monitoring, pack, packages, policies, Security, SQL Server

1
kudos

Kudos

How to troubleshoot database corruption errors and System Center…

published 768 days, 4 hours, 51 minutes ago posted by

sa 777 days, 5 hours, 26 minutes ago

How to troubleshoot database corruption errors and System Center…

Here is the great post from Bob Ward on how best you can understand and troubleshoot the error messages & warnings that will occur within your SQL estate along with Systems Center monitoirng tool. Just a note from that blog: .... This team approached myself and others in CSS and asked us to review what “database corruption” errors were being alerted as part of the management pack and whether the advice given matched that of CSS. What we found was let’s say “room for improvement”. A colleague...(read more) (more)

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

tags: DBA, edition, error log, Monitoring, SQL Server, systems center, warning

1
kudos

Kudos

Oracle DBA Year One

published 768 days, 4 hours, 51 minutes ago posted by

sa 777 days, 7 hours, 36 minutes ago

About a year and a half ago, I took a position managing the SQL Server and Oracle DBA teams. I find myself gravitating towards Oracle just because there is a lot to learn. So what have I learned? Oracle smashes SQL Server and visa versa. It all depends on your measuring stick. Hypothetically If I had [...] (more)

category: News | clicked: 1 | comment | | source: jasonmassie.com

tags: DBA, oracle, Other, retard strength, SQL Server

1
kudos

Kudos

Rise of the SQL Server DevBA | AdaTheDev

published 799 days, 7 hours, 6 minutes ago posted by

AdaTheDev 809 days, 3 hours, 44 minutes ago

Rise of the SQL Server DevBA | AdaTheDev

"DevBA" - an SQL Server Developer with a bit of DBA thrown in. As a developer, broadening your horizons to a DBA's mindset can offer great benefits and add to your skillset. (more)

category: Management | clicked: 3 | comment | | source: www.adathedev.co.uk

tags: DBA, Developer, SQLServer

1
kudos

Kudos

SQLBits - The 6th Sets :: theme is performance and scalability

published 809 days, 6 hours, 45 minutes ago posted by

sa 816 days, 8 hours, 20 minutes ago

SQLBits - The 6th Sets :: theme is performance and scalability

In the database world Performance and Scalability goes in line like a railway track! In parallel SQLBits conferences are more popular in UK and Europe, where you get real-world content to learn and share. For the year 2010 it is SQLBits - The 6th Sets our latest, and if we may be so bold, our greatest event yet. The theme is performance and scalability, anything and everything that you can think on that theme. Once the sessions are submitted and ready for voting, registration will open around the...(read... (more)

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

tags: Best Practices, Conference, DBA, meeting, Performance, real world example, Scalability, SQL Server, SQLBits

1
kudos

Kudos

Imagine a 3500 Page Book…

published 911 days, 17 hours, 24 minutes ago posted by

sa 921 days, 6 hours, 39 minutes ago

having 400-500 level SQL Server internals content WITH (COMPRESSION=PAGE) that gets it down to char(140) per page. The changing face of community I am talking about Paul Randal’s twitter feed. Tweet after tweet of internals and storage engine goodness. I hope to take a little credit for getting Paul on twitter. Peer pressure is tough. Although, [...] (more)

category: News | clicked: 0 | comment | | source: jasonmassie.com

tags: DBA, Hazardous material removal, social computing, SQL Server, twitter, zoopr0n

1
kudos

Kudos

Achieve SQL Server 2008 High Availability and Disaster Recovery - technical case study, SQLBits

published 912 days, 17 hours, 29 minutes ago posted by

sa 922 days, 5 hours, 54 minutes ago

Achieve SQL Server 2008 High Availability and Disaster Recovery - technical case study, SQLBits

How can you achieve the High Availability & Disaster Recovery on database platform? What are factors involved to keep the system available to maintain revenue stream? What kind of management principles you need to implement? Well there are lot more questions involved to the subject, only few important that I have listed above and in this regard on the topic agenda I'm speaking in a major SQL Server User conference in UK on 20th November 2009 - SQLBits V register here if you haven't done yet!...(read more) (more)

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

tags: architect, Best Practices, database mirroring, databases, DBA, disaster recovery, high availability, platform, SQL Server, Technology

1
kudos

Kudos

SQL Server Manageability tips - Quick view on Object Explorer and its best usage

published 929 days, 18 hours, 44 minutes ago posted by

sa 939 days, 8 hours, 23 minutes ago

SQL Server Manageability tips - Quick view on Object Explorer and its best usage

As a SQL Server user Object Explorer is one component that you will never miss when you are using SQL Server Management Studio, in specific from version 2005 onwards. As it states this connects to Database Engine instances, Analysis Services, Integration Services, Reporting Services, and SQL Server Compact 3.5. A brief view of all the objects in the server and presents a user interface to manage them. But not many out there knew the capabilities of how best the Object Explorer's can be used and it...(rea... (more)

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

tags: beginner, Best Practices, DBA, file search, fillter, Management Studio, Object Explorer, SQL Server, usage, user connections

1
kudos

Kudos

Usergroup meeting: SQL Server Performance Analysis Tools and Powershell

published 957 days, 21 hours, 38 minutes ago posted by

sa 967 days, 8 hours, 49 minutes ago

Usergroup meeting: SQL Server Performance Analysis Tools and Powershell

Another exciting news from Scottish Area SQL Server User Group meeting on October 08th 2009 [Thursday] with the topic: SQL Server Performance Analysis Tools and Powershell. The topic itself is very interesting in terms how DBAs will tackle the performance issues and give you a glimpse of tools that are available with SQL Server 2008 where you can perform your own analysis, also a glimpse of Powershell for a DBA. The evening can get you a starter of how it will for upcoming SQLBits V conference ....(read ... (more)

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

tags: analysis, Best Practices, Conference, DBA, Performance, rob, SQL Server, SQLBits, Tools, usergroup

1
kudos

Kudos

Can you be too Thorough?

published 965 days, 22 hours, 14 minutes ago posted by

sa 968 days, 21 hours, 39 minutes ago

Can you take thoroughness to a fault? There are some things that cannot be taken too far like intelligence. In a business setting, have you ever met someone who was just too smart(competitors do not count)? How about too honest? Too skilled? Too good with customers? I do not think thoroughness fails into this category [...] (more)

category: News | clicked: 1 | comment | | source: jasonmassie.com

tags: DBA, Professional Development, SQL Server, SQL Server 2008, twitter

1
kudos

Kudos

Session Voting Open for SQLBits V - don't forget to even if you are not attending!

published 966 days, 22 hours, 19 minutes ago posted by

sa 970 days, 10 hours, 34 minutes ago

Session Voting Open for SQLBits V - don't forget to even if you are not attending!

To continue the story about SQLBits V conference and list of sessions that I have submitted , here is news for you to participate in voting. If you are registered on the site you can now vote on the sessions you want to see at the next SQLBits. Voting is Open Have your say on what sessions are chosen for the Saturday. Go to the Community Day Sessions and vote Its vital that you vote so that you get the sessions. If you don't we've no idea it you would prefer index tuning or piano tuning Why it is...(read... (more)

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

tags: Conference, DBA, Developer, europe, management, sessions, SQL Server, SQLBits, usergroup, voting

1
kudos

Kudos

Directly Opening a Solution in SQL Server Management Studio

published 986 days, 23 hours, 48 minutes ago posted by

sa 994 days, 18 hours, 3 minutes ago

Directly Opening a Solution in SQL Server Management Studio I use Solutions a lot in SQL Server Management Studio (SSMS), and you should be aware of this simple tip: If you want to open a Solution without having to open SSMS and then jumping through all the menus, just double-click the solution name in the Windows folder. It will automatically open the Solution and SSMS at the same time. This tip, by the way, also works with any .SQL files, unless you've installed another product that has that file ass... (more)

category: Management | clicked: 0 | comment | | source: blogs.msdn.com

tags: DBA, Developer, Development, SQL Server, SQL Server Management Studio, SSMS, Tips

1
kudos

Kudos

Rodney Landrum's Free e-Book: "SQL Server Tacklebox"

published 1001 days, 20 hours, 28 minutes ago posted by

sa 1006 days, 22 hours, 38 minutes ago

Rodney Landrum's Free e-Book: "SQL Server Tacklebox"

Red Gate just published a new free e-book in their High Performance SQL Server series. The book is SQL Server Tacklebox: Essential Tools and Scripts for the Day to Day DBA by Rodney Landrum. Rodney is a professional DBA by trade, an author by choice, and a SQL Server MVP. With the SQL Server Tacklebox Rodney demonstrates dozens of commonplace DBA tasks, approaching each from different perspectives. Whether it's walking the reader through all the steps to properly install a SQL Server instance or demonst... (more)

category: Community | clicked: 3 | comment | | source: sqlblog.com

tags: Book, DBA, mvp, red gate, rodney landrum, Scripts, tacklebox

2
kudos

Kudos

DBA Compliments

published 1014 days, 23 hours, 55 minutes ago posted by

sa 1020 days, 16 hours, 16 minutes ago

“Wow, the application sure is smoking today.” “You know, Bob, I cannot remember the last time SQL was down. You sure are doing a good job.” “Gee, is the log always that big or are you happy to see me?” Ha, every production DBA knows those compliments NEVER happen. We have a thankless job. No one ever notices until the database is down. Think I am kidding? When was the last time you told your Exchange buddy how solid the mail server has been? Well, I am tal... (more)

category: Community | clicked: 2 | comment | | source: jasonmassie.com

tags: automagic, DBA, Professional Development

2
kudos

Kudos

Upgrade but Avoid v1.0 Features

published 1015 days, 21 hours, 43 minutes ago posted by

sa 1020 days, 17 hours, 22 minutes ago

August 5, 2009 · Posted in SQL Server Holding off on the newest features sounds like a no brainer especially when the next SQL Server release seem a million years away and is BI focused. In the reality, I was partitioning tables the first night we upgraded to SQL Server 2005. I could not replace TEXT with VARCHAR(MAX) fast enough. Some DTS packages got hit with the shamwow and emerged in SSIS. All of these changes broke stuff. None of these were necessary. A straight upgrade of the engine would hav... (more)

category: Management | clicked: 3 | comment | | source: jasonmassie.com

tags: bugfix, DBA, SQL Server 2008, Upgrade

1
kudos

Kudos

Code Collapse and Expand Feature in SQL Server Management Studio 2008

published 1023 days, 25 minutes ago posted by

sa 1026 days, 18 hours, 29 minutes ago

Code Collapse and Expand Feature in SQL Server Management Studio 2008 In SQL Server Management Studio 2008, whenever you have a "block" of code (BEGIN....END, etc) SSMS will put a little plus-sign in the margin and allow you to "collapse" that block of code so you only see the BEGIN, not stuff underneath. If you're working with a really large set of code, that's helpful. But I got an e-mail from a friend that said her SSMS didn't do that. I was kind of surprised, since I never had to do anything to mak... (more)

category: Management | clicked: 19 | comment | | source: blogs.msdn.com

tags: DBA, Developer, Development, SQL Server, SQL Server 2008, SQL Server Management Studio, SSMS, Tips

Welcome!

DBA

SQL Server 2008 Best Practices Analyzer - keep an eye for the release

SQL Server in Virtual platform - keep a close watch on physical server's configuration

SQL Server detected a logical consistency-based I/O error: Error 824, take help of trace flags and event notifications

SQL Server Management Data Warehouse - quick tour on setting health monitoring policies

How to troubleshoot database corruption errors and System Center…

Oracle DBA Year One

Rise of the SQL Server DevBA | AdaTheDev

SQLBits - The 6th Sets :: theme is performance and scalability

Imagine a 3500 Page Book…

Achieve SQL Server 2008 High Availability and Disaster Recovery - technical case study, SQLBits

SQL Server Manageability tips - Quick view on Object Explorer and its best usage

Usergroup meeting: SQL Server Performance Analysis Tools and Powershell

Can you be too Thorough?

Session Voting Open for SQLBits V - don't forget to even if you are not attending!

Directly Opening a Solution in SQL Server Management Studio

Rodney Landrum's Free e-Book: "SQL Server Tacklebox"

DBA Compliments

Upgrade but Avoid v1.0 Features

Code Collapse and Expand Feature in SQL Server Management Studio 2008

Open ID Login

Standard Login

Forgot Password?

Sign up