A Script A Day - Day 15 - Untrusted Check Constraints
Today’s script comes about because of a recent discussion about check constraints. The discussion was about the use of WITH...
2012-02-22
1,026 reads
Blog Posts
A Script A Day - Day 16 - Database Restore
Today’s script is one I have used more times that I care to remember. As a DBA database backups and...
2012-02-22
680 reads
PASSMN Rocks 2012!
As many of you may know, I am the Chair for the Minnesota SQL Server User Group aka PASSMN. I...
2012-02-22
593 reads
SQL Server 2012 (“Denali”): FileTable
FileTable is a new feature in SQL Server 2012 that is built on top of SQL Server FILESTREAM technology, which...
2012-02-22
1,625 reads
A Script A Day - Day 13 - Chris' Top Tip - Batches
Today’s post is pretty cool. So you have been reading up about something on the World Wide Web or you...
2012-02-21
466 reads
A Script A Day - Day 14 - Upgrading to SQL 2012
Today’s script is one I have used to test one possible upgrade method from SQL Server 2008 to SQL Server...
2012-02-21
974 reads
Creating Your First SSAS 2012 Tabular Project
No matter how simple it is, new things come with some confusion; at least until you get used to it....
2012-02-21
4,577 reads
Desktop Edition Sql server 2000 MSDE Install upgrade
for sql server 2000 (I know its old) desktop edition does not includes any GUI. so installation of desktop edition...
2012-02-21
2,461 reads
Find Dependencies
Here's a script from my toolbox I use to find dependencies between SQL objects. The where clause has a number...
2012-02-21
1,041 reads
First Impressions
I was chatting with a friend recently who had been in turn chatting with a colleague about first impressions. The...
2012-02-21
970 reads
Blogs
Five Ways Redshift Serverless Quietly Eats Your Budget
It is Friday, the queries are running, and nobody is watching the bill. That...
A Career of Memories
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
Rethinking Index Maintenance: Why avg_fragmentation_in_percent Is Outdated and What You Should Do Instead
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
Forums
Alamat Kantor BCA KCP Bumiayu Telp:0817866887
WhatsApp:0817-866-887 Jl. Kalierang No.Ruko 3-5, Dukuhturi, Kec. Bumiayu, Kabupaten Brebes, Jawa Tengah 52273 (@bcakcpbumiayu)
BCA KCP Permata Ujung Menteng Tlp:0817839777
WhatsApp: 0817839777 Jl. Raya Bekasi Km. 25 Blok A/17, RW.18, Ujung Menteng, Wil, Kota...
Alamat Kantor BCA KCU RAWAMANGUN Tlp:0817839777
WhatsApp: 0817839777 Jl. Paus No.81, RT.1/RW.8, Wil, Kec. Pulo Gadung, Kota Jakarta Timur, Daerah...
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers