Profile cover photo
Profile photo
SansSQL
34 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.

34 followers
About
Posts

Post has attachment
Public
Tips to Move SQL Server Database from One Server to Another - A guest Post by Rajan Singh
Leading organizations always look to find different solutions for high-performance data replication and secure storage environment. One such step is to move SQL Server database from one server to its updated version. In fact, when you migrate SQL server dat...
Add a comment...

Post has attachment
Public
Big Data Use Cases in the Manufacturing Industry - A guest Post by Renu Bisht
Big data is processing of data collected from various sources in different formats. Big data may contain sensitive information which is important for the organisation to make decisions. According to a research, the market value of the Big data will achieve ...
Add a comment...

Post has attachment
Public
Trouble in Opening MDF File because it Says SQL Error 5171? - A guest Post by Andre Williams
MS SQL Server is the most widely used and deployed database server in organizations. But, there are times when the SQL Server database gets corrupted due to various reasons. Error messages like SQL Error 1571 are also frequent with SQL Server. Let’s learn m...
Add a comment...

Post has attachment
Public
How to add an additional Administrator to your Amazon AWS account
To create an additional administrator in your AWS account, follow the below steps Login to your AWS Management Console https://console.aws.amazon.com/  Search for the "IAM" service In the left navigation panel, select "Users". Choose "Add User" Provide the ...
Add a comment...

Post has attachment
SQL Coding Best Practices and Design Considerations
As the business demand the applications to be more flexible and user friendly, the data access layers become more critical. For the applications to be flexible and quick responsive, the database reads and writes should be at optimum performance levels leavi...
Add a comment...

Post has attachment
T-SQL to find Memory Used by Database and its Objects
When a data page is read from disk, the page is copied into the SQL Server buffer pool and cached for reuse. Each cached data page has one buffer descriptor. Buffer descriptors uniquely identify each data page that is currently cached in an instance of SQL ...
Add a comment...

Post has attachment
Find Isolation Level of transaction and Database
Find Isolation level of a transaction SELECT session_id AS SessionID,
program_name AS ProgramName,
DB_NAME(database_id) AS DatabaseName,
CASE transaction_isolation_level
WHEN 0 THEN 'Unspecified'
WHEN 1 THEN 'ReadUncommitted'
WHEN 2 THE...
Add a comment...

Post has attachment
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...
Add a comment...

Post has attachment
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...
Add a comment...

Post has attachment
Power BI Architecture for Enterprises
Add a comment...
Wait while more posts are being loaded