Hide the Ribbon in Power View
There may come a day when you want to embed a Power View report into a PerformancePoint dashboard or a...
2013-06-07
715 reads
Bradley Schacht
SharePoint 2010 on SQL 2012 Configuration Failed
Recently while doing an installation of SharePoint 2010 on a Windows Server 2008 R2 server with a SQL Server 2012...
2013-05-29
1,169 reads
Creating a SharePoint 2013 Demo Environment – Part 1: Setting Up A Domain Controller
Development and demo environments can be hard to come by. Over the course of this series you will learn how...
2013-05-21
2,277 reads
Browse SharePoint in Windows Explorer
Have you ever wanted to browse your SharePoint 2010 site in Windows Explorer? If you are in SharePoint 2007 please...
2013-05-14
877 reads
SQL Saturday Jacksonville 2013 Wrap-up
It was another great year at SQL Saturday Jacksonville. For the last several years I have been lucky enough to...
2013-05-07
471 reads
Why I’m Considering a Surface and Windows Phone 8
Anyone who knows me will see the title of this post and tell you I’m about to trash the Surface,...
2013-03-22
665 reads
SSIS 2012 Deadlock When Running SSIS from SQL Agent Job
I recently had an interesting situation where an SSIS package was scheduled to run at 1 AM but failed with...
2013-03-18 (first published: 2013-03-12)
4,998 reads
Remove Local Administrators SSAS Admin Access
Recently while changing some production security around on a new server I needed to modify the SQL Server Analysis Services...
2013-03-05
1,198 reads
Find Skew in Distributed Tables
The SQL Server PDW (Parallel Data Warehouse) is a beast of a machine. Spreading workload across multiple nodes inside the...
2012-09-11
1,504 reads
Cisco VPN Client 5 on Windows 8
NOTE: Always create a backup before doing any type of Windows registry modifications!!!!
With the full public release of Windows 8...
2012-09-04
1,455 reads
Blogs
Azure SQL offerings
By James Serra
There are three Azure SQL products with so many different deployment options, service tiers,...
T-SQL Tuesday #183 Roundup
By Steve Jones
I hosted this month’s T-SQL Tuesday party with my invitation asking about tracking permissions....
A Little Brainstorming with an AI
By Steve Jones
I was asked to do some a little thinking and brainstorming recently. Rather than...
Forums
MEMORYBROKER_FOR_RESERVE experience
Hi, Does anyone have experience with MEMORYBROKER_FOR_RESERVE ? when suddenly there is somehow constantly...
Moving Database Files
I just learned that my database was created on my C:\ drive in the...
Migrate MSSQL to MYSQL - Different Servers
I am needing to migrate a MSSQL db to MySQL, on a different server...
Question of the Day
Mixed Backups
I have a complex database with a few filegroups and files. Can I run a backup command like this? (assume file/filegroup names are valid).
BACKUP DATABASE [complex]
FILE = N'thirdone'
, FILE = N'thirdtwo'
, FILEGROUP = N'second'
TO DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL16.SQL2022\MSSQL\Backup\complex.bak'
WITH NOFORMAT, NOINIT, NAME = N'complex-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO
See possible answers