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.
Migrating SQL Reporting Services to a new server
I need to move all the objects off the 2005 Reporting Server to the 2008 Reporting Server. Is there an easy way to do this without saving each report file (edit report and save .rdl) then uploading the report to the new server? This would also mean recreating the data sources and subscriptions.
Key Storage
Today Steve Jones asks about how you secure the keys that secure your other data. Is there a good way that you've found to handle this?
Sequences in SQL Server 2012
This article describes the sequence new feature used in SQL Server 2012
Migration Guide: Migrating to SQL Server 2012 Failover Clustering and Availability Groups from Prior Clustering and Mirroring Deployments
This paper provides guidance for customers who prior to SQL Server 2012 have deployed SQL Failover Clustering for local high availability and database mirroring for disaster recovery, and who want to migrate to SQL Server AlwaysOn. It describes the corresponding SQL Server AlwaysOn scenario and the migration paths to SQL Server AlwaysOn. It also contains the important knowledge and considerations that you must know in order to successfully migrate to a HADR solution based on SQL Server AlwaysOn technology, which implements AlwaysOn Failover Cluster Instances for high availability and AlwaysOn Availability Groups for disaster recovery.
Transfer Times in the Cloud
Today Steve Jones talks about a problem in the cloud computing world: getting your data back.
How to Connect to a SQL Server Named Instance
My network admins have tightened down the network and while we were once able to connect to our named instances via MySQLServer\MyNamedInstance, we're now only able to connect if we specify the port. What happened and what do I need to tell them to fix the issue?
Blogs
ISACA AI Material/Exam Prep Discount (May 18 – June 30, 2026)
By Brian Kelley
If you are considering any of the ISACA AI certs like the Advanced Artificial...
A Fabric solution can be very cost effective
By ChrisJenkins
Are you currently using Microsoft Fabric or considering migrating to it? If so, there...
Track SQL Server Configuration Changes Using the Error Log
By SQLPals
Track SQL Server Configuration Changes Using the Error Log If you...
Forums
Alamat kontak resmi BCA KCP Pahlawan Telp:0817866887
Tlp/Wa_Cs:0817-866-887 Jl. Khp Hasan Mustopa No.108, Padasuka, Kec. Cibeunying Kidul, Kota Bandung, Jawa Barat...
Alamat kontak resmi BCA KCP Dewi Sartika Telp:0817866887
WhatsApp:0817866887 Jl. Dewi Sartika No.58, Balonggede, Kec. Regol, Kota Bandung, Jawa Barat 40251
SQL Server Showing Out of Space But Plenty of Drive Space
We have a SQL Server installed. We have a 500GB drive for the database....
Question of the Day
Creating a JSON Document IV
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT YearEstablished, json_objectagg(city : TeamName) FROM dbo.NFLTeams GROUP BY YearEstablished;See possible answers