Tags » SQL Server

SQL Server Catalog Views Information Schema Views Metadata List of all tables views databases

To get metadata in SQL server such as list of all databases, or tables, views residing in a database we can use:

SQL Server

New Session: Data Types Do Matter

I started speaking on a semi-regular basis this year after many years of trepidation.  You can read about my first speaking experience here.  It’s three years later and I have discovered that I love speaking.  176 more words

Professional Development

Looking at dbatools github with Power BI

First of all! Really, really thanks dbatools team for this. I don’t have words to describe the impact that you guys have in my job. I use it every single day! 463 more words

VirtualPass

SQL Query to get list of all modified Stored Procedures order by date

SQL Query to get list of all modified Stored Procedures order by date

select name,create_date,modify_date
from sys.procedures
order by modify_date desc

SELECT name
FROM sys.objects… 19 more words

SQL Server

Windows 7 and 8.1 getting new cumulative updates, download offline installers

After releasing total 6 cumulative updates to the different versions of Windows 10 operating system, Microsoft is now rolling out the new cumulative updates to Windows 7 and Windows 8.1, although Microsoft ended mainstream support for Windows 7 on January 13, 2015, the company extended the security support until January 14, 2020. 470 more words

Updates

Rx for Demystifying Index Tuning Decisions – Part 4

— by Jeffry Schwartz

Review

In Parts 1 through 3 of this blog series the author discussed various aspects of SQL Server indices such as: 1,392 more words

SQL Server

SQL Smackdown!!! Cursors VS Loops

Ladies and Gentlemen, welcome to the main event of the evening.  The SQL Undercover Smackdown Heavy Weight Championship of the World! 

In the red corner, we hate him, we loath him, I’ve even heard people say he should be deprecated, it’s the Cursor!!! 

1,201 more words
Database Administration