Sometimes end users interchange the terms : C2 auditing and Traces. They server different purposes. c2 auditing records all attempts (successfull and failed) on objects and statements. Typically a SQL Server DBA will use a c2 audit to monitor security compliance . A trace will will monitor an event or...
There are three tools I use every day without exception. They all save me valuable time in surfing the net: Delicious – This is a free bookmarking tool that works so much better than the built-in bookmarking in IE. You can install a Delicious toolbar that allows you to bookmark a page like IE does...
BIDS helper is Visual Studio add-in with features that extend and enhance the functionality of the SQL Server 2005 and SQL Server 2008 BI Development Studio. Version 1.5 can be downloaded here , and read up on the new features . It’s a must-have add-in with tons of features . I find myself using...
Extensions or Add Ins save application development time and make smart code. Visual Studio has vast list of these extension available. I am giving brief about some very useful and powerful extension here, but before this you need to know how to install these extensions. How to Install Extensions Open...
Malathi Mahadevan works as a Senior DBA with Kindred Healthcare – a healthcare services company based out of Louisville, KY and ranked first in Fortune magazine's Most Admired Companies "Health Care: Medical Facilities" category . She is the founder-lead of the local chapter of Professional...
Introduction This is a review of a tool we evaluated as a possible solution for auditing our environment. The Environment Most companies that have regulations such as HIPAA/Sarbanes Oxley compliance need some kind of audit tool that monitors activity on critical production servers. The environment I...
Download the SQL Server 2008 R2 from the image library. This may take awhile as it’s a 5.5 GB. I prefer to do it from a local copy of files, as over the network it can take awhile. From the command line run the following command. C:\[SQLImagesPath]\setup.exe /ACTION=INSTALL /QUIET /FEATURES=CONN...
Whenever the new version of SQL Server is released the first thing I search for Books Online update to upgrade the local copy. In similar to that Microsoft have been releasing lot of free resources and tools that can enhance the learning experience for Developers, DBA and Architects. So here are few...
Posted to
SQLMaster
by
Satya Jayanty
on
09-27-2010
Filed under:
Filed under: best practices, dba, #SQL Server, sql server 2008 r2, #DBA, developer, #DOTNET, reporting services, tools, usage, beyond relational, visual studio
I thought it would be useful to list the range of software utilities I use when managing SQL Server. They cover object management, monitoring, troubleshooting, code writing, copying lareg files. I specifically haven't added Profiler even throughI use it extensively. I'd be interested in hearing...
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. ....read more....
SQL Server Compact 3.5 SP2 Server Tools Windows Installer (MSI) file installs replication components on the computer running the Internet Information Services (IIS) for synchronizing data with SQL Server 2005, SQL Server 2008 and SQL Server 2008 R2 November CTP. SQL Server Compact 3.5 SP2 Server Tools...