Tags » Microsoft SQL Server

Extracting DMV information from SQL Server

Extracting DMV information from SQL Server:

  1. Build view to get information

create view justdave_dmvs as
SERVERPROPERTY(‘productversion’) productversion,
SERVERPROPERTY (‘productlevel’) productlevel,
SERVERPROPERTY (‘edition’) edition,
REPLACE(REPLACE(REPLACE(@@VERSION, CHAR(13),”),CHAR(10),”),CHAR(9),”)serverversion, 97 more words

Microsoft SQL Server

Safely Remove Old SQL User and Schema

In older versions of Microsoft SQL Server (and Sybase?), a separate database schema was created for each database user. This caused confusion and resulted in non-standard fully qualified object names like jsmith.tabname rather than dbo.tabname. 159 more words


The tail of the log

The tail of the log

A little while back I was feeling overwhelmed by the number of blog posts ideas that I had so I asked around if anyone wanted one. 111 more words

Microsoft SQL Server

SQL Server Reporting Services - Report Manager returns 404 page not found

Today I was setting up new development environment with SQL Server 2014 and SSRS. After setting it up, I tried to connect to Report Manager (via URL specified in Reporting Services Configuration Manager) but I was constantly getting 404 page not found error. 99 more words


Microsoft SQL Server 2016 – New features and enhancements

This version of SQL Server is going to be a major release with new features and will also overcome some limitations of SQL Server 2014. 350 more words

SQL Server

How to attach MS SQL Server database (mdf file) without corresponding log (ldf) file

When attaching SQL Server database, you should have database file (mdf) and transaction log file (ldf). If transaction log file is missing, you won’t be able to attach database through SQL Server Management Studio. 145 more words


SSMS's Clipboard Manager

The other day Richie Rump (b/t) mentioned something called a clipboard manager on twitter. I’ll admit I had to ask what exactly they meant, but once it was described to me I realized it was something I’d wanted off and on for years. 128 more words

Microsoft SQL Server