Profile cover photo
Profile photo
SansSQL
30 followers -
SansSQL is a blog dedicated for SQL Server geeks out there on SQL Server Administration related topics, tips and tricks. In this blog we will also discuss about T-SQL, Business Intelligence and Data Warehousing.
SansSQL is a blog dedicated for SQL Server geeks out there on SQL Server Administration related topics, tips and tricks. In this blog we will also discuss about T-SQL, Business Intelligence and Data Warehousing.

30 followers
About
SansSQL's posts

Post has attachment
Public
T-SQL to List all Permissions for a Given Role
This script lists all the permissions for a given role. SELECT DB_NAME() AS DatabaseName
,DatabasePrincipals.name AS PrincipalName
,DatabasePrincipals.type_desc AS PrincipalType
,DatabasePrincipals2.name AS GrantedBy
,DatabasePermiss...

Post has attachment
Public
T-SQL to get Get Database Files Usage information
Here is an handy T-SQL script to get Database files usage Information DECLARE @FreeSpaceThreshold int
SET @FreeSpaceThreshold = 20 -- Change this Threshold Value. Any number between 0 to 100

CREATE TABLE #GetDetails
(
ServerName nvarchar(100),
DatabaseN...

Post has attachment
Public
Power BI Architecture for Enterprises


Post has attachment
Public
T-SQL script to get Backup Details of a Database and the Sequence it was taken
Here is an handy script which give the details of the list of backup(s) taken of a database and the sequence it was taken. DECLARE @db_name VARCHAR(100) SELECT @db_name = '<DB Name>'

SELECT
BS.server_name AS [Server Name]
,BS.database_name AS [Database Na...

Post has attachment
Public
Kernel for SQL Database - Product Review - A guest Post by Andre Williams
Most of the organizations that handle large amount of data is very much dependent on MS SQL Server for their operations. However, an MS SQL database corruption, can cause a lot of troubles to the organization owing to the criticality of the data contained i...

Post has attachment
Public
Using DBCC CLONEDATABASE to generate a schema and statistics only copy of a user database in SQL Server 2014 SP2
DBCC CLONEDATABASE is a new DBCC command introduced in SQL Server 2014 SP 2 which is used for creating the clone of a specified user database which helps in troubleshooting the performance issues related to the query optimizer. When a clone of the database ...

Post has attachment
Public
SQL Backup Recovery Tool to Repair Damaged SQL Backup - Product Review - A guest Post by Daniel Jones
It has been commonly observed that many users are inclined to store the important and crucial data in SQL Server due to its reliable and consistent data storage feature. All the data is stored efficiently in data files i.e. MDF and NDF files. Unfavourable s...

Post has attachment
Public
How to use SSRS reports as Data Source in Excel
As we all know SSRS is a server-based reporting platform that allows to create and manage a wide variety of reports, and deliver them in a range of formats, but many of them are still addicted to the excel for reporting as it is more convenient and easy to ...

Post has attachment
Public
Embed SSRS Report into PowerPoint Slides
Presentations are one major activity in each and everyone's career. There are different ways of presenting your information, some does it just by showing the static data and some wants to do it with the Live data. We are the people who are of type 2, presen...

Post has attachment
Public
How to Enable Remote Errors in SSRS
Enabling Remote Errors includes external error information (for example, error information about report data sources) with the error messages that are returned for users who request reports from remote computers. By default the remote errors in SSRS is set ...
Wait while more posts are being loaded