(Rakki Muthukumar) I saw some extra traffic on my website last week, and as an old school IIS guy I wanted to run Log Parser against my website logs. In Azure Websites, the traditional IIS logs are stored at %home%LogfileshttpRawLogs, those are of W3C format.
Tag: sql server
USING SQL & POWERSHELL – Different Methods to List Databases WITH Recovery Models
(prashanthjayaram) One of op requested to list all the user defined databases where it has been configured with simple recovery model across ‘N’ servers.There are many ways to achieve the requirement.
Questions about T-SQL Expressions You Were Too Shy to Ask
(Robert Sheldon) Nobody seems to ask questions about SQL Expressions in forums, even though expressions can cause all sorts of problems. Even the books on T-SQL skate over them in haste to get to more complicated topics.
Checking the number of SQL Server connections for SQL connection ‘Timeout period elapsed’ error
(Steve Endow) I recently had to troubleshoot an issue with a Dynamics GP third party product that would hang with the error:
Database – Beginning with Cloud Database As A Service
(Pinal Dave) I love my weekend projects. Everybody does different activities in their weekend – like traveling, reading or just nothing.
Get Ready to Learn SQL Server: 6 – Group and Summarize Your Results
(Kris Wenzel) In today’s lesson you’re going to learn about grouping results returned from your queries using the GROUP BY clause.
SQL SERVER – Introduction to SQL Server 2014 In-Memory OLTP
(Pinal Dave) In SQL Server 2014 Microsoft has introduced a new database engine component called In-Memory OLTP aka project “Hekaton” which is fully integrated into the SQL Server Database Engine. It is optimized for OLTP workloads accessing memory resident data.
#SQLServer – Where does my index live?
(Stuart Ainsworth) Today, I got asked by one of my DBA’s about a recently deployed database that seemed to have a lot of filegroups with only a few tables. He wanted to verify that one of the tables was correctly partition-aligned, as well as learn where all of the indexes for these tables were sto
Effects of sp_rename on Stored Procedures
(Jason Brimhall) There comes a time when mistakes are made. Sometimes those mistakes can be as annoying as a spelling mistake during the creation of a stored procedure. When a mistake such as that happens, we are given a few choices.
More than sp_help
(Kenneth Fisher) If you have worked with SQL Server for very long you have probably run across the extremely useful system function called sp_help. This handy little function will return a list of the objects in the database if you don’t pass in a parameter.