May 16, 2008
Follow an IT team through a late-night troubleshooting session involving Microsoft CRM, SQL Server Reporting Services, Microsoft IIS, and Kerberos.
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
Heed this advice about how to identify duplicate or redundant indexes on the tables in your databases.
May 2008
Learn how to build proper dimensions, add useful hierarchies that support user’s navigational needs, then perform the important step of adding attribute relationships to make your users' data analysis fast and easy.
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.
April 29, 2008
After you build the proper dimensions of a cube, you need to add attribute relationships to help the cube engine better process queries for faster data analysis.
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.
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.
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 2008
Using a database named MyDB, a table named MyTable, and some dummy tables, you can learn how to create T-SQL queries that insert new data, update existing data, and delete old data.
March 2008
Easily debug packages, Control Flow tasks, and Data Flow tasks and log package-execution information using the debugging and logging capabilities in SSIS.
March 28, 2008
Find out how to assign a compatible data type to the data destination(s) early in the pipeline to avoid data-type conflicts.
April 2008
Build efficient queries using LINQ, which is included in Visual Studio 2008.
April 2008
Get answers to your questions about SQL Server 2005 Surface Area Configuration tools that can help you protect the SQL Server surface area from security breaches perpetrated by unauthorized users or applications.
March 2008
Build a sample application in Visual Studio that can be used to manage hierarchical rowsets populated by stored procedures.
March 2008
Whether you are new to T-SQL or you just want to brush up on the basics, you'll want to read and save this guide that walks you through how to write SELECT statements. Learn how to order and rename columns and how to filter and sort results.
March 2008
More answers to DBAs' questions. What’s the difference between dividing an integer with NULL or zero, or between a unique constraint and a primary key constraint, or between decimal and numeric data types? And how do you retrieve random rows from a table?
February 27, 2008
To make the sample TableAdapter application more useful as a general demonstration, I added several features that illustrate a few tricky technical points, including how to import a picture, handle new row initialization, and provide a list of addresses.
February 7, 2008
This week, Brian discusses what it means to be an expert in a field and whether it's a good career move to become a PerformancePoint Server expert.
February 2008
PerformancePoint Server 2007 might be in your future, especially if your users find out about its BI features. Get the lowdown before they do about the 3 parts of PerformancePoint Server, what it needs to run, and what exactly it delivers.
Add these Headlines to your Website
