SQL – Find encrypted objects using sql_modules or Powershell
sys.sql_modules catalog view which got introduced from SQL 2005 onwards. The sql_modules which includes the objects of type P, RF, V, TR, FN, IF, TF,...
2014-04-14
739 reads
Blog Posts
SQL – Find encrypted objects using sql_modules or Powershell
sys.sql_modules catalog view which got introduced from SQL 2005 onwards. The sql_modules which includes the objects of type P, RF, V, TR, FN, IF, TF,...
2014-04-14
821 reads
SQL Server – Different Ways to Check Object Definition
sp_helptext is widely used for checking object definition in SQL Server. sp_helptext can be used to check definition of various...
2014-04-14
294 reads
SQL Server – Different Ways to Check Object Definition
sp_helptext is widely used for checking object definition in SQL Server. sp_helptext can be used to check definition of various...
2014-04-14
1,065 reads
SQL Server – Different Ways to Check Object Definition
sp_helptext is widely used for checking object definition in SQL Server. sp_helptext can be used to check definition of various...
2014-04-14
126 reads
SQL Server – How To Find SQL Virtual Name From Host Name in SQL Failover Clustering Using PowerShell
Often times it is required to find out the SQL name from the host names in a clustered environment so you...
2014-04-14
1,175 reads
SSIS XML Task
The XML Task in SSIS allows you to parse through an XML file and read the nodes in the XML....
2014-04-14 (first published: 2014-04-07)
3,345 reads
Using BMC Control-M to Automate Tasks
My largest client recently purchased BMC Control-M to use as our enterprise scheduler. Since this product went live in our...
2014-04-14 (first published: 2014-04-04)
4,001 reads
Hortonworks Data Platform 2.1 New Features
What is Hortonworks Data Platform
Hortonworks recently announced their release of the HDP 2.1 their Hadoop Big Data platform. If you...
2014-04-13
903 reads
Using the T-SQL MERGE Statement
In SQL Server 2008, Microsoft added a new SQL query type: the MERGE statement. This flexible query provides the ability...
2014-04-13
5,684 reads
Blogs
SQL Server Security: Always Encryption
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
A Las Vegas Break
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Identity Defaults
Comments posted to this topic are about the item Identity Defaults
Question of the Day
Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers