SqlServerKudos

DBA

1
kudos

Kudos

SQL Server - What is Transaction log file? Can I delete it? Think about Database Recovery Model too!

published 4 hours, 43 minutes ago posted by

sa 2 days, 6 hours, 13 minutes ago

SQL Server - What is Transaction log file? Can I delete it? Think about Database Recovery Model too!

This was the question asked by a developer, due to a particular process fills up the transaction log so quickly. I had to explain the reason and tricks that can reduce the transaction log bulge using best recovery methods on the database. Going back to basics there certain FAQ about Transaction log usage within SQL Server. Transaction Log - why it is required? A log is a seperate file that stores all kinds of information about the SQL Server instance and databases. Each database has its own log file...(r... (more)

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

tags: Best Practices, DBA, disk space, free space, log writer, size, SQL Server, transactionon log, vlf

1
kudos

Kudos

SQLBits 7 - 30 Sep to 02 October 2010, sessions open for voting

published 3 days, 4 hours, 54 minutes ago posted by

sa 12 days, 6 hours, 29 minutes ago

SQLBits 7 - 30 Sep to 02 October 2010, sessions open for voting

Here comes the 7 wonders of SQL conference - SQL Bits 7, this will take place from September 30 to October 02 2010 at York University . No doubt that SQLBits is the largest SQL Server conference in Europe and the previous six conferences have established it as a must-attend event for DBAs, developers and BI professionals who work with SQL Server and similar to last event SQLBits 6 in South Wales the event will be running the three day format that was so successful . Day one will be a training day,...(rea... (more)

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

tags: Best Practices, community, Conference, DBA, devloper, pre-con, SQL Server, SQLBits, Training

1
kudos

Kudos

SQL Server 2008 R2 new features specific to OS related Dynamic Management Views - DMV

published 13 days, 5 hours, 38 minutes ago posted by

sa 22 days, 7 hours, 34 minutes ago

SQL Server 2008 R2 new features specific to OS related Dynamic Management Views - DMV

How many times have you taken help from SQL Server DMVs? How many of them are useful for your day-to-day data platform management? Well, they are closely attached to my day-to-day work. I'm excited to get my hands on upcoming client's project about their SQL Server platform review on the aspects of providing roadmap for the data-tier form a performance & scalability aspects with an additional flavour of high availability. In such scenarios I always keep my DBA-toolkit (scripts & references)...(read more) (more)

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

tags: best practice, cpu, database user, DBA, DMV, Memory, server scope, SQL Server, SQL Server 2008 R2, sys.dm_os_

1
kudos

Kudos

Community here is your chance: Vote for 2010's Exceptional DBA Awards winner

published 19 days, 6 hours, 4 minutes ago posted by

sa 28 days, 7 hours, 59 minutes ago

Community here is your chance: Vote for 2010's Exceptional DBA Awards winner

Red-Gate tools needs no introduction to SQL Server users, they are encouraging best practices within the community by promoting awards such as Exceptional DBA of the year that has been started last year. So now the same contest we have six finalists instead of the normal five were named this year, reflecting the high quality of nominations. Now it's your turn to help us find the Exceptional DBA of 2010. Get to know the finalists and vote for the winner between June 23 and July 23, 11:00 hours (GMT)....(r... (more)

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

tags: Best Practices, code-plex, community, DBA, exceptional dba, red-gate, SQL Server, toolkit, vote

1
kudos

Kudos

SQL Server 2008 Security gotcha: BUILTIN\Administrator is no longer SYSADMIN, only in case of?

published 24 days, 6 hours, 29 minutes ago posted by

sa 32 days, 6 hours, 50 minutes ago

$SQL Server 2008 Security gotcha: BUILTIN\Administrator is no longer SYSADMIN, only in case of?$

Here is an interesting 'sql security' discussion I had during the SASSUG usergroup interaction with regard to BUILTIN\Administrator role from SQL Server 2008 onwards. Since SQL Server 2005 the instance has been classified as 'secured by design/default' by cutting down the elevated access to the SQL Server. From the operating system side login privilege, by default SQL adds the group BUILTIN\Administrators to the sysadmin fixed server role, meaning that any local NT administrator is automatically...(read ... (more)

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

tags: access, Best Practices, builtin\administrator, control, DAC, DBA, dedicated admin console, registry, Security, SQL Server, UAC, windows authentication

1
kudos

Kudos

Leverage Query and Index performance with MAXDOP/Max Degree of Parallelism option in SQL Server

published 28 days, 6 hours, 44 minutes ago posted by

sa 37 days, 6 hours, 10 minutes ago

Leverage Query and Index performance with MAXDOP/Max Degree of Parallelism option in SQL Server

No matter how best you adopt the indexing practices, few times you have to tweak the resources to obtain optimized performance. This is where a degree of parallelism needs to be applied for your complex/large resulted queries on your SQL Server, having a multiple CPU based server is a quite common criteria. By design SQL database engine with more than CPU detects the best degree of parallelism, that is number of processors employed to run a single statement, for each parallel plan execution. Unless...(re... (more)

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

tags: benchmarking, best practice, DBA, latches, max worker threads, maxdop, numa, parallel execution, Performance, performance monitoring, Query, SQL Server, threads

1
kudos

Kudos

SQL Server Hardware Checklist - a primer for DBA

published 31 days, 6 hours, 59 minutes ago posted by

sa 39 days, 9 hours ago

SQL Server Hardware Checklist - a primer for DBA

Every once in a while you might get into complexity in managing a process, even though it is a simple one! So this is where a checklist will come handy to ensure you do not commit any 'blunders' on your day-to-day business.You may relate the DBA checklist to Airline pilot's checklist who will always perform the drill without having any miss of list of chores when they fly. For every DBA a checklist to manage the platform is very helpful, I do have a list of points that I form as a checklist whenever...(r... (more)

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

tags: Best Practices, checklist, compatability, configuration, DBA, Hardware, SAN, setup, SQL Server

1
kudos

Kudos

SQL Server 2008 Best Practices Analyzer (BPA) available for download

published 31 days, 6 hours, 59 minutes ago posted by

sa 40 days, 8 hours ago

SQL Server 2008 Best Practices Analyzer (BPA) available for download

In followup to the SQL Server 2008 Best Practices Analyzer - keep an eye for the release post here, CSS SQL Server Engineers from PSSQL blog have announced that final development and testing were completed on the tool and it is now available for you to download at this location . The BPA tool gone through an overhaul from CSS SQL team on rules logic, design and guidance for known configuration settings, so it is nothing but scanning and getting most of real-world review of your environment. Also...(read ... (more)

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

tags: best practice analyzer, bpa, Compatibility, DBA, Documentation, download, policy based framework, rules, Security, SQL Server, Tool

1
kudos

Kudos

The SQL Server MasterClass Experience | AdaTheDev

published 31 days, 6 hours, 59 minutes ago posted by

AdaTheDev 40 days, 10 hours, 50 minutes ago

The SQL Server MasterClass Experience | AdaTheDev

SQL Server MasterClass 2010 was a very high quality, one day event presented by Paul S. Randal and Kimberly L. Tripp - not that they need any introduction of course. In fact if you don't know of them, then perhaps you should close down your SSMS window and switch off your machine - after reading my blog of course :). Maybe uninstall SQL Server too... The A-Team With two of the best SQL Server trainers in the industry offering a packed schedule of sessions, it was an... (more)

category: Community | clicked: 0 | comment | | source: www.adathedev.co.uk

tags: DBA, SQL, SQL Server, SQLServer

1
kudos

Kudos

XQuery Lab 57 – Getting Started with OPENXML

published 34 days, 7 hours, 10 minutes ago posted by

sa 43 days, 8 hours, 14 minutes ago

XQuery Lab 57 – Getting Started with OPENXML

This post intends to help you get started with OPENXML() function. OPENXML() lets you shred an XML document or fragment into a result set. Though OPENXML() has got no direct relationship with XQuery, I thought of including it in the XQuery Labs series Read More......(read more) (more)

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

tags: #XML, #XQUERY, database, DBA, OPENXML, sp_xml_preparedocument, sp_xml_removedocument, SQLServer, TSQL, XML, xquery, xquery labs

1
kudos

Kudos

SQL Server HA: Quick view of Database Mirroring session between partners

published 36 days, 7 hours, 20 minutes ago posted by

sa 44 days, 8 hours, 24 minutes ago

SQL Server HA: Quick view of Database Mirroring session between partners

From SQL Server 2005 version onwards database mirroring has been a good resource to provide High Availablity for the systems without having special hardware requirement. While I was assisting at the SME lounge within Database Platform area in Tech-Ed North America conference, I had few interesting questions from the users asking about various methods to monitor database mirroring environment. Database Mirroring Monitor is the tool which is a first hand resource to see what is happening within the...(read... (more)

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

tags: database mirroring, DBA, endpoint, instances, Monitoring, Performance, SQL Server, Troubleshooting

1
kudos

Kudos

FILESTREAM directory structure - where do the GUIDs come from? - Jacob's Blog

published 36 days, 7 hours, 20 minutes ago posted by

jacobsebastian 44 days, 9 hours, 26 minutes ago

FILESTREAM directory structure - where do the GUIDs come from? - Jacob's Blog

SQL Server uses GUID values to name the FILESTREAM folders and you might find it really hard to relate a folder to a table or column. This post explains how you can do it. (more)

category: Query | clicked: 0 | comment | | source: beyondrelational.com

tags: BLOB, DAC, database, DBA, filestream, SQLServer

1
kudos

Kudos

TSQL Challenge 32 - Clean up phrases by removing noise words - TSQL Challenges

published 37 days, 7 hours, 25 minutes ago posted by

jacobsebastian 45 days, 14 hours, 12 minutes ago

TSQL Challenge 32 - Clean up phrases by removing noise words - TSQL Challenges

The idea of this challenge is to clean up the phrase from the words identified as noise words, but only when these words appear at the begining or the end of the string, not in the middle of the string. Your job is to read each row from the source table and remove any noise words from it. The noise words that you need to remove are stored in another table. You should remove the noice words only if they appear at the beginning or end of the sentences. (more)

category: Query | clicked: 1 | comment | | source: beyondrelational.com

tags: Challenge, DBA, Developer, Puzzle, SQL Server, TSQL, tsql challenges

1
kudos

Kudos

SQL Server Setup Portal - a preview and planning of what you are about to setup?

published 63 days, 9 hours, 22 minutes ago posted by

sa 71 days, 11 hours, 41 minutes ago

SQL Server Setup Portal - a preview and planning of what you are about to setup?

There is a myth (rather a wrong impression) in database world that SQL Server setup is pretty easy, what you do is insert setup-media into drive and click next....next.....next, well it is not!!! Here is the opportunity to see the SQL Server 2008 R2 setup process, along with prepare & install/upgrade. There needs lot of consideration such as installation pre-requisites, features/editions, security considerations etc. and also the upgrade advisor, very useful tool to simulate the upgrade process...(read m... (more)

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

tags: best practice, DBA, Installation, Process, setup, SQL Server, SQL Server 2008 R2, step by step, upgrade advisor

1
kudos

Kudos

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

published 74 days, 10 hours, 11 minutes ago posted by

sa 83 days, 12 hours, 35 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 82 days, 10 hours, 45 minutes ago posted by

sa 91 days, 13 hours, 21 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 89 days, 11 hours, 16 minutes ago posted by

sa 98 days, 11 hours, 50 minutes 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 106 days, 12 hours, 36 minutes ago posted by

sa 116 days, 10 hours, 1 minute 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 107 days, 12 hours, 41 minutes ago posted by

sa 116 days, 13 hours, 16 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 107 days, 12 hours, 41 minutes ago posted by

sa 116 days, 15 hours, 26 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

Welcome!

DBA

SQL Server - What is Transaction log file? Can I delete it? Think about Database Recovery Model too!

SQLBits 7 - 30 Sep to 02 October 2010, sessions open for voting

SQL Server 2008 R2 new features specific to OS related Dynamic Management Views - DMV

Community here is your chance: Vote for 2010's Exceptional DBA Awards winner

SQL Server 2008 Security gotcha: BUILTIN\Administrator is no longer SYSADMIN, only in case of?

Leverage Query and Index performance with MAXDOP/Max Degree of Parallelism option in SQL Server

SQL Server Hardware Checklist - a primer for DBA

SQL Server 2008 Best Practices Analyzer (BPA) available for download

The SQL Server MasterClass Experience | AdaTheDev

XQuery Lab 57 – Getting Started with OPENXML

SQL Server HA: Quick view of Database Mirroring session between partners

FILESTREAM directory structure - where do the GUIDs come from? - Jacob's Blog

TSQL Challenge 32 - Clean up phrases by removing noise words - TSQL Challenges

SQL Server Setup Portal - a preview and planning of what you are about to setup?

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

Open ID Login

Standard Login

Forgot Password?

Sign up