Social Data Analysis
Today we have an editorial originally published on June 24, 2007. It is being republished as Steve is traveling. IBM has done some work to help people analyze sets of data with new visualizations.
Stairway to SQL Server Replication - Level 10: Troubleshooting
The final level of this Stairway takes you through how to identify and fix common errors.
Microsoft SQL Server 2012 - (SQLPS)
Prior to SQL Server 2012, Microsoft provided a mini shell called sqlps.exe; in SQL Server 2012, SQLPS exists in the form of module. Learn how to make use of the SQLPS module and how to access SQL Server components and features via Windows PowerShell.
PASS Data Architecture VC presents Todd McDermit on Data Warehouse Dimension Processing with SSIS from Simple to Complex
On Thursday April 19th 12PM noon Central, Todd McDermid will discuss "SSIS components for Data Warehouse Dimensional data processing".
Linked server to MySQL Server.
In this article, we are going to create a linked server to the MySQL Database.
Once finished that task, we will select, insert, update and delete some data using SQL Server.
The Best of the Best
Today's editorial was originally pubished on June 26, 2007. It is being re-run today as Steve is traveling. What were the best places to work in 2007? Steve Jones links to a list and talks about the value of using those lists.
Understanding Retention Periods for SQL Server Transactional Replication
I have transactional replication configured in production. I have heard about the replication retention period, but what is the significance of this. Would there be any impact to my replication configuration if data is not synchronized with the subscriptions within the retention period?
Big Data
Are you prepared for Big Data? A short piece from Henrico Bekker that talks about what Big Data might mean to many people.
Open Source Software and Cacoëthes Scribendi
Phil Factor on the irresistible urge to write code in the public domain, and the occasional desire to be free from the snails-trail of software that needs maintainence.
TSQL Challenge 80 - Find the minimal set of intervals without gaps
The challenge is to find the minimal set of intervals without creating gaps.
Blogs
KDA: Echoes of Deception - Case 6
By Zikato
A cryptic message, a book cipher hidden in art provenance records, and a trail...
Capturing My Own Metrics: #SQLNewBlogger
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
Forums
ALAMAT KANTOR BCA KCU KISARAN TLP/WA 08218200174
Telp Cso: (0821)8200174 Jl. Cokro Aminoto No.28, Kisaran Kota, Kec. Kota Kisaran Barat, Kabupaten...
ALAMAT BCA KCU PEMATANG SIANTAR TLP/WA 08218200174
Telp Cso: (0821)8200174 Jl. Merdeka No.39, Proklamasi, Kec. Siantar Bar., Kota Pematang Siantar, Sumatera...
ALAMAT KANTOR BCA KCU ASIA TLP/WA 08218200174
Telp Cso: (0821)8200174 Jl. Asia, Simpang, Jl. Bakaran Batu No.1 C, Sei Rengas II,...
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