Why I am excited about SQL Server 2012
By now many of you have had the opportunity to hear or see something about the next release of SQL...
2012-03-08
673 reads
Blog Posts
Backing up a Certificate
If you create your own certificate in SQL Server, you need to make sure that you back it up immediately....
2012-03-07 (first published: 2012-02-27)
10,786 reads
Enabling Filestream in SQL Server 2012
Filestream is a cool feature, albeit one that’s cumbersome to use in SQL Server 2008 and R2. However the FileTable...
2012-03-07
3,646 reads
I’m sorry, you’ve committed a GIANT INTERNET FAIL (#SQL2012)
Updated with links to no-login goodness. Updated again with IE rage.
This week, Microsoft announced the SQL Server 2012 release to...
2012-03-07
931 reads
Intel Xeon E5-2600 Series Processors Released
Yesterday, Intel finally released the much anticipated Xeon E5-2600 family of processors, also known as Sandy Bridge-EP. This is a...
2012-03-07
1,231 reads
Physical or Virtual
Today I get to share something that has been on my someday list for quite some time. I have planned on getting a solution that involves TSQL to help...
2012-03-07
15 reads
Physical or Virtual
Today I get to share something that has been on my someday list for quite some time. I have planned...
2012-03-07
2,137 reads
PowerPivot 2012 RTM Release
Somewhat overshadowed, for obvious reasons, by the big RTM release of SQL Server 2012 was the RTM release of PowerPivot...
2012-03-07
1,187 reads
SQL Server – sys.master_files and list all database files
Use the system view “sys.master_files” for a single view of databases and database files.
Instead of using sys.sysfiles joing to sys.sysdatabases...
2012-03-07
1,453 reads
SQL Server 2012 (“Denali”): Reporting Services in SharePoint integrated mode
In SQL Server 2008, if you wanted to run Reporting Services in SharePoint integrated mode, these where the steps you took...
2012-03-07
4,509 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 KCU KALIMALANG Tlp/Wa:0817839777
Tlp/Cs: 0817839777 Jl. Tarum Barat Blk. E No.5, RT.4/RW.10, Wil. Kota, Kec. Duren Sawit,...
Alamat Kantor BCA KCU SITUBONDO Telp:0817839777
WhatsApp: 0817839777 Jl. Diponegoro No.68, Palraman, Dawuhan, Kec. Situbondo, Kabupaten Situbondo, Jawa Timur 68311
Alamat Kantor BCA KCU TUBAN Telp:0817839777
WhatsApp: 0817839777 Jl. Panglima Sudirman No.35, Baturetno, Kec. Tuban, Kabupaten Tuban, Jawa Timur 62314
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers