Configuring PerformancePoint in SharePoint 2013
Last week while assisting a customer configure SharePoint BI I ran into an interesting problem when configuring PerformancePoint. After following...
2013-04-29
1,901 reads
Quick Tip: Where’s my SQL Server Job History?
Here’s a quick mystery. You have a SQL Server with several jobs that appear to be running properly and on...
2013-04-29
1,207 reads
PowerSQL -Recycle SQL Instance (Remote or Local)
We have a scheduled maintenance window to recycle SQL SERVER Instance once in 30 days hence created a PowerShell job where...
2013-04-29
1,397 reads
Last Weeks Top “Reading” Links #30
For those that follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of...
2013-04-29
1,339 reads
How to provide a better customer service
Thomas La Rock (Blog | Twitter) recently wrote a blog post about misplacing a device he has called a FitBit One which...
2013-04-29
1,724 reads
Looking Back-Part 2
As I re-read the original Looking Back post I realized I didn’t include anything about the fear part – stepping away...
2013-04-29
1,261 reads
Error while enabling Windows Feature: Netfx3
Recently I was setting up a virtual machine environment to do some demo’s. One of the virtual machines would be...
2013-04-29
9,053 reads
Creating a Shared Dataset with Report Builder
I was recently asked by a customer if you could build a Shared Dataset using Report Builder 3.0. More specifically,...
2013-04-29
2,928 reads
DMV-9 : Digging out details of CLR Tasks……..sys.dm_clr_tasks
sys.dm_clr_tasks DMV (Dynamic Management View), described by BOL as follows: http://msdn.microsoft.com/en-in/library/ms177528.aspx
Returns a row for all common language runtime (CLR) tasks...
2013-04-29
1,799 reads
Limit running Powershell script under specific path with AppLocker
Say if you have a management server or a script repository server, sometimes users save/test/run their script from different path,...
2013-04-28
1,384 reads
Blogs
T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
Monday Monitor Tips: Configuring Access to the MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, including the Redgate...
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers