Delivering reports is becoming more critical due to the increasing demand for business intelligence solutions. And while there are a lot of guides that walk us through building a highly available database engine, you’ll rarely see one for SQL Server Reporting Services. How do I go about building a scale-out SQL Server 2008 R2 Reporting Services running on Windows Server 2008 R2?
If you are a Database Administrator, Developer or IT team lead, take part in our survey and you could win one of three $50 Amazon gift certificates. It will only take you 10-15 minutes.
Why are sites still being hit by SQL Injection on a large scale? Steve Jones talks about a recent large scale attack that affected over a million sites.
In this article, Ron Johnson shows how you can use DMVs for proactive real-time SQL Server performance monitoring.
The deadline for entering the DBA in Space competition has been extended until Nov 22, 2011, noon GMT. Enter today and get the chance to fly into space or take the vacation of your dreams.
On Thursday November 17th at 8PM Eastern, Steve Simon will discuss "No Matter how well planned and executed, data structures sometime resembles something out of a Dr. Seuss book."
With the DBA in Space contest ending this week, Steve Jones has some thoughts on the contest, and what he'd do if he were to win.
We have a new forum setup for your Powerpivot questions. If you are working with Powerpivot, please feel free to ask questions here.
SQL Server 2008 and later offers the ability to create compressed backup files. When creating the compressed backup, how much space is really needed and when does the space get allocated for the backup file?
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Many years ago, before I joined Oracle, I was working on a major modernisation...
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
WA:08218154393 Jl. Palmerah Barat No.38 A, RT.2/RW.3, Grogol Utara, Kec. Kebayoran Lama, Kota Jakarta...
WA:08218154393 Jl. RC. Veteran. 9, dan No.9A, RT.9/RW.3, Bintaro, Kec. Pesanggrahan, Kota Jakarta Selatan,...
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37What is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 3;See possible answers