Tribal Awards 2014 Winners
We have the winners of the 2014 Tribal Awards. Congratulations to everyone involved: winners, finalists, and nominees, and thank you to everyone who voted or nominated someone for an award.
SQL Server Reporting Services Basics: Deploying Reports
Having designed and tested our reports, it's time to deploy them to the Report Server, so that our users can access them. Kathi Kellenberger demonstrates how to configure reports for native-mode deployment using Report Manager, and then deploy them from within SSDT-BI. She also explains how to use the Report Builder to provide "self-service" reporting to end users, allowing them to build custom reports based on report parts and shared datasets.
Taking Care of Things Today
Steve Jones talks about procrastination today and how you might not want to do that with your SQL Servers.
Untrusted Foreign Keys with NOT FOR REPLICATION Option on the Key
My Foreign Keys are STILL untrusted after the double CHECK. Here's how you can fix this issue.
Questions About Pivoting Data in SQL Server You Were Too Shy to Ask
Of all the basic SQL operations, the pivot seems to cause the most problems. It turns out that there are several questions that come to mind while learning about pivoting, but which are seldom asked on forums.
Returning Sorted Record Sets Using the ORDER BY Clause
Having your data returned to you in some meaningful sorted order is important sometimes. If you don’t tell SQL Server you want to order the results of a SELECT statement then there is no guarantee that your result set will come back in a particular order. To make sure a result set is ordered you need to use the ORDER BY clause. In this article I will be exploring how to return an order result set by using the ORDER BY clause.
A Little Empathy
Perspective makes a big difference and Steve Jones looks at how you might change the way you think about clients, customers, and the work you do.
Prevent sp_ Procedures with SQLCop
Learn how you can use SQLCop to prevent your developers from writing stored procedures that are named sp_ something.
Data Cleaning in SQL 2012 with Data Quality Services
Feodor Georgiev provides a thorough walkthrough on setting up SQL Server's Data Quality Services (DQS) and creating the rules it uses to function as a first step towards data cleansing.
Blogs
Learn about Modern Microsoft Apps in San Diego
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
How To Deploy Fabric SQL and Azure SQL Databases with Azure DevOps
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
A New Word: Attriage
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
Forums
ALAMAT BCA KCU BENGKULU TLP/WA 08218154374
Hub Cs:08218154374 Jl. S. Parman No.66, Kebun Kenanga, Kec. Ratu Agung, Kota Bengkulu, Bengkulu...
ALAMAT BCA KCU BUKITTINGGI TLP/WA 08218154374
Hub Cs:08218154374 Jl. Sudirman No.59, Bukit Cangang Kayu Ramang, Kec. Guguk Panjang, Kota Bukittinggi,...
ALAMAT KANTOR BCA KCU PADANG TLP/WA 08218154374
Hub Cs:08218154374 Jl. H. Agus Salim No.10 A, Sawahan, Kec. Padang Tim., Kota Padang,...
Question of the Day
BIT_COUNT II
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