Blog Posts

SQL Server 2016 offers Row Level Security, which sounds awfully cool. It’s apparently been available in Azure for a while,...

2016-02-25

1,121 reads

Grabbing Fitbit Data

by Steve Jones

SQLServerCentral Blogs

Recently the T-SQL Tuesday topic was Power BI. A cool topic, and an interesting application.
I saw Rob Farley build a...

2016-02-24

1,328 reads

Memory Fundamentals for SQL Server - SQL Server Memory Components, SQL Server Memory Logical Tree

by kruti15ars

Kruti's SQL Blog

In the Previous blogs we have seen about virtual memory related concepts.
http://sqlandmorewithkruti.blogspot.in/2016/01/memory-fundamentals-for-sql-server.html

We came across concepts like Address Window Extension, Physical...

2016-02-24 (first published: 2016-02-22)

4,085 reads

Powershell script to create multiple SQL Server Connections

by Kenneth Fisher

SQLStudies

As with most of these types of things, I had a need. I want to show how using sys.dm_exec_[requests/sessions/connections] is...

2016-02-24

1,066 reads

Query Store and Recompile

by Grant Fritchey

The Scary DBA

One of the many advantages of SQL Cruise is the ability to have enough time during a presentation to be...

2016-02-24

631 reads

SQL – List Server and DB Permsission

by Prashanth Jayaram

PowerSQL By Prashanth Jayaram

Database Level Permission
DECLARE@DBuser_sql VARCHAR(4000)DECLARE@DBuser_table TABLE(
DBName VARCHAR(200),
UserName VARCHAR(250),
LoginType VARCHAR(500),
AssociatedDatabaseRole VARCHAR(200))SET@DBuser_sql='
SELECT "[?]" AS DBName,a.name AS Name,
a.type_desc AS LoginType,
USER_NAME(b.role_principal_id) AS AssociatedDatabaseRole
FROM [?].sys.database_principals a
LEFT OUTER...

2016-02-24

636 reads

SQL Filegroup/File Proportional Fill Algorithm

by Mr Fox SQL

Mr. Fox SQL

[read this post on Mr. Fox SQL blog] I had a question at work recently where there was some confusion around how SQL Server allocates data across data files within a filegroup...

2016-02-24

18 reads