Will the New PASS Summit Attendees be Back?
Despite the down economy, the 2009 PASS Summit attendance was down only 8% compared to the 15% of other conferences...
2009-11-13
371 reads
Articles
Database defintion from an Excel Spec?
Have you ever been required to create a database with nothing but a specification in Excel?
2009-11-12
7,674 reads
Consolidating Again and Again and Again
Virtualization is touted as a great way to save money, but it's a one time event. Once you've consolidated a server, you can't do it again. However consolidation isn't necessarily the same and Steve Jones tells us why.
2009-11-12
509 reads
Consolidating Again and Again and Again
Virtualization is touted as a great way to save money, but it's a one time event. Once you've consolidated a server, you can't do it again. However consolidation isn't necessarily the same and Steve Jones tells us why.
2009-11-12
802 reads
Consolidating Again and Again and Again
Virtualization is touted as a great way to save money, but it's a one time event. Once you've consolidated a server, you can't do it again. However consolidation isn't necessarily the same and Steve Jones tells us why.
2009-11-12
527 reads
SQL Azure TSQL
SQL Azure is very similar to traditional SQL Server and now supports many standard TSQL commands. This article demonstrates the use of TSQL commands to create SQL Azure objects.
2009-11-12
3,874 reads
A Better Way To Install Updates
The decisions to install service packs and cumulative updates is often confusing to new DBAs. Many of them install every update, often without a good reason. Steve Jones asks why we might not have a better way to install updates, maybe even helping us decide if we need them.
2009-11-11
337 reads
A Better Way To Install Updates
The decisions to install service packs and cumulative updates is often confusing to new DBAs. Many of them install every update, often without a good reason. Steve Jones asks why we might not have a better way to install updates, maybe even helping us decide if we need them.
2009-11-11
346 reads
A Better Way To Install Updates
The decisions to install service packs and cumulative updates is often confusing to new DBAs. Many of them install every update, often without a good reason. Steve Jones asks why we might not have a better way to install updates, maybe even helping us decide if we need them.
2009-11-11
380 reads
Best Practices – When Using FILESTREAM Feature of SQL Server 2008
In SQL Server 2008 one can store BLOBs (e.g. Images, video, Word, Excel, PDF, MP3, etc) in the NTFS file system rather than in a database file. This can be done by using the new FILESTREAM feature which was introduced in SQL Server 2008. In this tip we will take a look at some of the best practices which a database administrator can follow to get the best performance when using the FILESTREAM feature of SQL Server 2008.
2009-11-11
4,240 reads
Blogs
Methodology for dealing with bad data in production
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
How to Provision an Azure SQL Database
Aside from spinning up a SQL Server instance container, the free Azure SQL Database...
Claude finds two cryptographic weaknesses (but the sky isn’t falling)
By Brian Kelley
If you haven't seen the announcement, Anthropic was able to utilize Claude (Mythos Preview)...
Forums
Kontak BCA KCP Semanggi Telp:08218154392
WA CS (08218154392) Wisma GKBI, Jl. Jenderal Sudirman No.28 Suite G 01, RT.14/RW.1, Bend....
Why SQL Server Database Attach fails and how to repair it
Comments posted to this topic are about the item Why SQL Server Database Attach...
Fixing P1 Queries
Comments posted to this topic are about the item Fixing P1 Queries
Question of the Day
BIT_COUNT() IV
In SQL Server 2025, I run this code:
select bit_count('A')
What is returned? See possible answers