(Deanna Dicken) Beginning with SQL Server 2005, column-level encryption and decryption capabilities where made available within the database. This provides a compelling solution for situations where one-off types of data need to be secured beyond your existing authorization, authentication or firew
Other News
On generating unique IDs using LAST_INSERT_ID() and other tools
(Shlomi Noach) There’s a trick for using LAST_INSERT_ID() to generate sequences in MySQL. Quoting from the Manual:
IBM Cognos Proven Practices: Conditional Business Reporting Based on Relative and Absolute Dates within IBM Cognos Report Studio
(Sonal Bhatt) An approach to presenting a ‘relative date’ to a report consumer within a prompt or set of prompts. Many organizations might need relative date activity such as the activity in the last 7 days, Month to date, Year to Date.
Managing SQL Job History Log and SQL Error Log
(Kun Lee) When you install SQL Server, it has a few default configuration settings for SQL Server to manage logs. In some instances, where servers generate too much log info and you need to look at the log it takes a long time to pull up.
Custom Reports in SSMS
SSWUG Free Expo Event: Real-World SharePoint Administration Today from 9 a.m. – 1 p.m. PST Be ready if you signed up for the SharePoint Administration Expo today…It starts at 9am Pacific Standard Time DBTechCon – Spring 2011 The SSWUG Spring 2011 virtual conference is quickly coming together. You can go to the registration page and see profiles for presenters, and […]
SQL Server Management Studio Standard Reports
SSWUG Free Expo Event: Real-World SharePoint Administration – Tomorrow Friday, February 11, 2011, 9 a.m. – 1 p.m. PST Build your skills for deploying and supporting SharePoint by attending this virtual expo. Experts will teach you techniques for managing access control, implementation strategies and tips you can use immediately. With registration you also receive a free complimentary membership to SSWUG […]
Troubleshooting SQL Server I/O requests taking longer than 15 seconds – I/O stalls & Disk latency
(Sakthivel Chidambaram) SQL Server has encountered x occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [Drive:MSSQLMSSQL.1MSSQLDataxyz.mdf] in database [database]. The OS file handle is 0x00000000. The offset of the latest long I/O is: 0x00000000000000
Compression of XML file, FTP upload and SQL Server SqlBulkInsert
(Micke Blomquist) This article describes one approach to upload data from a backend database to a frontend SQL database hosted on a web server using FtpWebRequest, GZipStream and SqlBulkInsert classes in .NET. The solution consists of two different parts; one application running on one machine; for
Project Apollo casts light on column-store indexes in SQL Server Denali
(Roman Rehak) Last year Microsoft introduced PowerPivot, a new add-on for Excel designed to let less-technical users create business intelligence (BI) applications.
MarkLogic: Extracting useful information from a server/cluster support dump
(Alex Bleasdale) Hopefully this will be a useful tip. In a situation where you need to extract information from a support dump, here are some examples involving loading the entire support dump as a sequence of document-node() elements and then pulling information out of them: