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,642 reads
Blog Posts
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,229 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,133 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
4 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,186 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,452 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,500 reads
SQL Server 2012 Data Mining add-in for Excel 2010 Released
Another release that went without much trumpeting was the SQL Server 2012
Data Mining add-in for Excel 2010. This has...
2012-03-07
1,672 reads
SQL Server Database Mirroring (Not Dead Yet)
SQL Server Database Mirroring is a high availability and disaster recovery feature that was added to the product with SQL...
2012-03-07
3,084 reads
Blogs
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Setting FK Constraints in Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Forums
Inspection And Auditing | FARE Labs Pvt. Ltd.
At FARE Labs Pvt. Ltd., our inspection and auditing services focus on precision, quality...
Microsoft Security Changes and SQL Server
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers