TSQL Challenge 40 - Convert string representation of numeric values fr
This challenge involves converting numeric values from binary format to hexadecimal format.
2010-10-04
1,656 reads
Articles
Standardize data storage for geography spatial data type in SQL Server
Geography is one of the spatial data types introduced in SQL Server 2008. One of the characteristic of the geography data type is that it can accommodate any supported geometry based on any supported spatial reference system in the same field. So if the data that is stored in a column of geography data type is not standardized, it can be a very tedious and resource intensive task to figure out the geometry and spatial reference system associated with each value. To deal with this issue, we need to standardize the data stored in a field of that has the geography data type and in this tip we will look at how to deal with this issue.
2010-10-04
2,316 reads
The Lone Ranger And Data Integrity
Many IT Pros can relate to the the Lone Ranger. With the aid of but one trusty side kick, the...
2010-10-04
2,238 reads
Partitioning in SQL Server 2008
This article discusses about 'Partitioning'. In this detailed article, a particular emphasis is placed on the implementation of Partitioning in SQL Server.
2010-10-01 (first published: 2009-04-29)
63,668 reads
PowerShell Version 2: What is new and why is it important?
It was a year ago that Microsoft shipped PowerShell 2. Jonathan Medd lists the top ten reasons why PowerShell 2 should be an important tool for your work
2010-10-01
4,489 reads
SQL Saturday 52 Recap
I spent this past weekend traveling to and attending SQL Saturday Colorado in the outskirts of Denver. This was the...
2010-10-01
2,608 reads
SQL Saturday#52 – Colorado Recap
This past weekend was the first SQL Saturday in Colorado, and it went very well. I think everyone enjoyed it,...
2010-10-01
1,391 reads
The SQL Server Quiz
There's a SQL Server quiz taking place during the next 31 days, challenging you to answer questions from a number of SQL Server experts and MVPs.
2010-10-01
2,954 reads
Moving Indexes with Powershell and SMO
Using Powershell with SMO, learn to alter or move indexes easily in this new article from Zach Mattson.
2010-09-30
4,619 reads
2010-09-30
5,572 reads
Blogs
Moving On-Prem PostgreSQL to the Cloud: Picking the Right Path for Big Tables
Every PostgreSQL migration eventually hits the same fork in the road. The database is...
A Spread of Vacation
By Steve Jones
I’m off on vacation today. Which is a little weird as I just got...
How AgentDBA Identifies Backup Failures
By Arun Sirpal
Every DBA has a box like this. Sitting untouched for months. Nobody’s proud of...
Forums
ALAMAT KONTAK BCA KCP ABC Telp:08218154393
WA:08218154393 Jl. ABC No. 23-25, Braga, Kec. Sumur Bandung, Kota Bandung, Jawa Barat 40111
ALAMAT BCA KCP Sunda Mal Telp:08218154393
WA:08218154393 Jl. Sunda No.50-54, Kb. Pisang, Kec. Sumur Bandung, Kota Bandung, Jawa Barat 40112
Have you done a Mid year check in?
Comments posted to this topic are about the item Have you done a Mid...
Question of the Day
Independence Day 2026
In the original Independence Day movie (1996), what type of computer did Jeff Goldblum use to connect to the alien mainframe? Take a guess, don't look it up or ask AI.
See possible answers