(Brian P ODwyer) We have over a hundred SQL Server instances with versions from SQL Server 2000 to SQL Server 2012 some of which are physical servers, but the majority being VMware virtual servers. While we have some access to the vSphere Client Console and the vSphere Web Client there is still more
Tag: sql server
Update zero base column to one base
(Derik Hammer) A co-worker requested help with a query today…
Implementing A Basic LIKE/Wildcard Search Function In Power Query
(Chris Webb) Last week someone asked me whether it was possible to do the equivalent of a SQL LIKE filter in Power Query. Unfortunately there isn’t a function to do this in the standard library but, as always, it is possible to write some M code to do this.
Power Pivot: Managing Refresh
(Chris) Power Pivot workbooks need to be refreshed on a schedule. One of the coolest things about Power Pivot is that all that time that users had to spend gathering and scraping data from here, there, and everywhere is how seamless Power Pivot makes it.
SQL SERVER – Fix – Agent Starting Error 15281 – SQL Server blocked access to procedure ‘dbo.sp_get_sqlagent_properties’ of component ‘Agent XPs’ because this component is turned off as part of the security configuration for this server
(Pinal Dave) SQL Server Agent fails to start because of the error 15281 is a very common error.
Understanding SQL Server Log Sequence Numbers for Backups
(Simon Liew) This tip describes SQL Server Log Sequence Numbers (LSNs) and how the sequence numbers link full, differential and transaction log backups. We will look at sample backups and how these LSN values can be read from the backup files to determine the restore path.
Extract Report RDL with PowerShell
(Allen White) With all the new features in recent versions of SQL Server, I’ve been helping clients with upgrading their SQL Server environments lately.
From the MVPs: SQL Server 2014 Performance Enhancements
(Shehap El Nagar) Database Performance has become an important subject for any database administrator, database Analysts and IT Directors. That is why Microsoft has focused on the performance factor within SQL Server 2014 to achieve 10x-30x improvement without touching your code whatsoever, they did
How to Implement full text search in your mobile application using Azure Mobile Services
(Jesus Aguilar) Search is one of those features that users expect and could be challenging to implement for mobile applications. In this blog post I will show how you can implement full text search capabilities for your mobile application using Azure Mobile Services with a .NET backend.
Can you partition a temporary table?
(Jason Brimhall) Reading that title, you might sit and wonder why you would ever want to partition a temporary table. I too would wonder the same thing. That withstanding, it is an interesting question that I wanted to investigate.