Mairead introduces you to how to create your database project using the latest edition of Visual Studio Team System - Team Edition for Database Professionals. Check out this quick 10 minute demo to get a whirlwind tour of project creation within VSTE for DB Pro.
This article explains how desktop applications can use SQL Server 2005 Data Mining to analyze in-memory data.
We're blowing out inventory again to make room for new books. Stock up your SQL Server library with a few of our titles.
SQL Server 2005 has made it much easier to work with XML data in your database applications than ever before. In this article, new author Jack Hummer examines how you can use XML to move data through stored procedures.
Continuing the overview of Data Flow components in SQL Server 2005 Integration Services, this installment focuses on the Lookup transformation.
Database snapshots provide a handy way to provide data integrity for Integration Services. In this presentation, Brian shows you how to create a package that can "self-heal". In the event of any problem, the database will automatically roll back to a pre-ETL snapshot.
Ownership chains have unique permissions' issues in SQL Server 2005. Contributor Serdar Yegulalp explains the access levels of ownership chains, and the benefits of "EXECUTE AS."
Our look at the SQL Server development team continues with Craig Freedman, query tuning expert working on partitioning features. Read a little about a talented software engineer that has been developing database software for over a decade.
Come to the PASS Summit this year and see three of the big influences on SQL Server: Steve Ballmer, Paul Flessner, and Dave Campbell. They're all giving keynotes. And did I mention SQLServerCentral.com is giving away an XBOX 360? Read more about it.
The File Watcher Task does what it says really, it watches a folder waiting for files. When an available file is found the task completes, returning the name of the file for later use.
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
WA:08218154393 Jl. Raya Ciawi No.151, Pakemitan, Kec. Ciawi, Kabupaten Tasikmalaya, Jawa Barat 46156
WA:08218154393 Jl. Jenderal Sudirman No.74, Pati Kidul, Kec. Pati, Kabupaten Pati, Jawa Tengah 59114
Comments posted to this topic are about the item SSRS Reminded Me of the...
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37 4 NULLWhat is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 4;See possible answers