Be the first to try Redgate SQL Compare 12
Hot on the heels of the SQL Server 2016 general release, the team at Redgate have just released beta builds for both SQL Compare and SQL Data Compare. As well as support for SQL Server 2016, these releases introduce a brand new user interface, and squash a whole host of bugs. In this blog post, Carly Meichen takes a closer look at what's new, and explains how you can give the development team your feedback and requests.
Looking at VIEWs, Close Up
Views in SQL can be difficult. It isn't easy to judge when to use them, It isn't always obvious how to determine if a view can be indexed or if it is updateable. Joe Celko takes a tricky topic and comes up with some helpful guidelines.
A New Sample Database
Microsoft has released the first version of a new sample database for SQL Server.
How to Query Comma Seperated Value Columns in SQL
Karthik provides a simple solution to querying a table that has comma separated values.
Accept Failure
Today Steve Jones talks about the risk inherent in any project, and how we should be aware of our mistakes, learn from them, and sometimes just give up when we've made too many.
Using LAST_VALUE
When I began using LAST_VALUE, the results were not what I expected at all. Read on to learn the secret!
The End of Big Data
What is next for big data? Some experts claim that data "volumes, velocity, variety and veracity" will only increase over time, requiring more data storage, faster machines and more sophisticated analysis tools. However, this is short-sighted, and does not take into account how data degrades over time. Analysis of historical data will always be with us, but generation of the most useful analyses will be done with data we already have. To adapt, most organizations must grow and mature their analytical environments. Lockwood Lyon shares the steps they must take to prepare for the transition.
Blogs
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Tell It Once: Setting Up Claude With Skills and MCP Servers
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident
By SQLPals
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...
Forums
BCA KCP Millennium Centennial Telp:0821-8200-233
Telp/Wa 62 8218200233 Gedung Millennium Centennial Ground Floor Unit C, Jl. Jenderal Sudirman No.Kav....
Alamat BCA KCP Pasar Cipulir Telp:0821-8200-203
Telp/Wa 62 8218200203 Komp. Cipulir Permai, E Jl. Ciledug Raya No.9, RT.9/RW.5, Ulujami, Kec....
Alamat Kantor BCA KCP Manhattan Tlp:0821-8200-233
Telp/Wa 62 8218200233 The Manhattan Square, Mid. Tower, Lt. Ground Unit A & Lt....
Question of the Day
Hyperscale Replicas II
How many Azure SQL DB Hyperscale HA replicas can be configured as of Sept 2026?
See possible answers