Introduction to SQL Server 2008 Report Builder 2.0
I have heard that there is a new version of Report Builder in SQL Server 2008. Can you provide some details and examples?
2009-03-05
4,254 reads
Additional Articles
The LEVEL_UNIQUE_NAME Intrinsic Member Property
SSAS Architect Bill Pearson examines another intrinsic member property, LEVEL_UNIQUE_NAME, which allows us to exercise a great deal of presentation “sleight of hand” in working with MDX in Analysis Services, as well as within Reporting Services and various other reporting applications that can access an Analysis Services cube.
2009-03-05
1,511 reads
Importing and exporting bulk data with the bcp utility
The SQL Server bcp utility can help administrators easily import or export bulk data between text files and SQL Server tables.
2009-03-04
4,119 reads
Perils of adding fields to database tables
Adding a field to a database table is sometimes not as simple as it may seem. If certain situations are not considered when adding fields, you may find yourself looking at some long nights fixing database code. Today, database consultant Tim Chapman looks at two such scenarios, and how you can plan for their occurrence.
2009-03-04
4,537 reads
SQL Server Encryption Key Management between Development, Test and Production Environments
The company I work for has decided to use the encryption technology available in SQL Server 2005. We have almost everything ironed out except for which keys to use in the development, testing, and production environments. Should we use one key for all three environments or different keys for each?
2009-03-03
2,865 reads
The Safe and Easy Way to Delete All Data in a SQL Server DB
Deleting all the data in a SQL Server database doesn't have to involve complex code. The undocumented stored procedure sp_MSForEachTable safely bypasses built-in limitations to accomplish this common task.
2009-03-03
4,786 reads
Finding the Worst Performing T-SQL Statements on an Instance
Greg Larsen introduces some Dynamic Management Views (DMVs) and Dynamic Management Functions (DMFs) to help monitor your application's T-SQL performance. In addition, he provides a Stored Procedure that utilizes the DMVs and DMFs to produce a report that quickly identifies poorly performing T-SQL statements.
2009-03-02
5,852 reads
Processing XML files with SQL Server functions
Loading and processing XML files into SQL Server tables can be simple, thanks to a method that uses SQL Server functions and XPath expressions.
2009-03-02
2,790 reads
A first look at Visual Studio 2008 Database Edition
Learn about Microsoft Visual Studio Team System 2008 for database professionals, a useful tool for database development with Microsoft SQL Server.
2009-02-27
4,544 reads
Creating and Using Databases in Android
Every application uses data, and Android applications are no exception. Android uses the open-source, stand-alone SQL database, SQLite. Learn how to create and manipulate a SQLite database for your Android app.
2009-02-27
1,630 reads
Blogs
Claude finds two cryptographic weaknesses (but the sky isn’t falling)
By Brian Kelley
If you haven't seen the announcement, Anthropic was able to utilize Claude (Mythos Preview)...
Generate Embeddings in SQL with Aurora and Bedrock
Most embedding pipelines on AWS have the same shape: a job reads rows out...
Resolving SQL Server Transaction Log Issues Efficiently
By Arun Sirpal
Transaction log issues are one of the quietest ways a healthy database turns into...
Forums
Symmetric Key Encryption
Comments posted to this topic are about the item Symmetric Key Encryption
The “Successful Login” Dilemma: Why Your Login Auditing Strategy Might Be Hurting Your Server
Comments posted to this topic are about the item The “Successful Login” Dilemma: Why...
Building Your Own Software
Comments posted to this topic are about the item Building Your Own Software
Question of the Day
Symmetric Key Encryption
If I run this statement in SQL Server 2025, how is the password encrypted?
CREATE SYMMETRIC KEY MySymmetricKey WITH ALGORITHM = AES_256, KEY_SOURCE = 'My secret key source passphrase', IDENTITY_VALUE = 'My secret identity value' ENCRYPTION BY PASSWORD = 'S&perS#cretP@ssword7'; GOSee possible answers