May 5, 2008
Michael Otey wraps up the SQL Server Express Reporting Services report he's worked on in his series of articles and shows how to deploy it.
May 5, 2008
Disabling the SQL Server row-count feature can help optimize T-SQL stored procedures and batches.
May 5, 2008
Welcome to Michael Otey's new blog, where he covers not only SQL Server Express and T-SQL, but Windows Server 2008, Vista, Hyper-V, VMware ESX Server, and more.
April 29, 2008
Common Criteria Compliance is an advanced configuration option available in SQL Server 2005 SP1 (SP2 is under review). Government, military, financial, and other entities with serious security needs may require its certification and implementation.
April 29, 2008
Help meet compliance goals by using SQL Trace, SQL Server Profiler, and C2 audit mode. View stored procedure examples that demonstrate audit logging with these features, and take a brief look at SQL Server 2008 auditing and third-party options.
May 2008
Fortify the security of your SQL Server environment by using an assortment of tools for locating servers, identifying security best practices, cracking passwords, and finding vulnerabilities.
May 2008
These solutions help protect your SQL Server environment from unwanted modification by registering changes to data, server configurations, and schemas. Find out which one you can use to roll back changes or to migrate databases to a different platform.
May 2008
SELECT queries aren't just for retrieving data. You can also summarize that data by incorporating COUNT, MIN, MAX, AVG, and SUM functions into SELECT queries.
May 2008
Ensuring that databases are being backed up properly is an important but time-consuming task, especially for DBAs who manage multiple servers and databases. The sp_ShowBackups stored procedure makes this task quick and easy.
May 2008
Handling distribution of events over time is tricky. Break the problem into steps. If handling all of a task’s requirements at once is too complicated, relax some requirements, solve a simpler form of the problem, then reintroduce the complexity layers.
May 2008
Get the solution to April’s puzzle, “Suicidal Mosquito,” and prepare your mind for May’s puzzle, which involves distance calculation.
April 29, 2008
Third-party transaction-log analyzers and gateways can audit logs and process and filter SQL Server traffic. They can analyze backup logs and use listener agents to collect and process SQL Server traffic to filter out the good stuff.
May 2008
Michael looks at some of SQL Server 2008's benchmark scores and discusses why the TPC-E benchmark currently isn't useful for comparing database platforms.
April 22, 2008
We recently met with Panorama to discuss its partnership with Google and latest product offerings.
April 21, 2008
Michael Otey responds to reader questions about how transactions work, when and where the data is written, and whether the data is put into the database before the transaction is committed.
April 16, 2008
Sharp-eyed observers reported code vulnerable to a possible SQL injection attack to Oklahoma state prison officials.
April 9, 2008
This week, Derek discusses the Report Designer Preview feature that will be included with SQL Server 2008.
April 7, 2008
Are you running Windows Vista? If so, you'll want to check out the improvements that SP1 provides.
Add these Headlines to your Website
