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
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Forums
The New World Of AI Robots
Comments posted to this topic are about the item The New World Of AI...
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Execute as failure
Security has long been a problem for me. Every time I think I understand...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers