2016-06-27
1,359 reads
Views
2016-06-09
1,448 reads
Looking at VIEWs, Close Up
Views in SQL can be difficult. It isn't easy to judge when to use them, It isn't always obvious how to determine if a view can be indexed or if it is updateable. Joe Celko takes a tricky topic and comes up with some helpful guidelines.
2016-06-07
6,986 reads
2015-07-27
1,623 reads
Finding SQL Server views with (or without) a certain property
In this tip Aaron Bertrand uses SQL Server metadata queries to discover SQL Server views that have certain properties or use certain syntax.
2014-12-12
5,919 reads
Using Views to Expose Encrypted Data in SQL Server
I'm using SQL Server's built-in encryption to hide data in one of my SQL Server databases, but this is a reporting system and my end users need to be able to query the data without having to remember the specialized decryption functions. Is there a way to do this? Yes, there is, via the use of views.
2013-10-29
4,794 reads
2013-08-01
2,376 reads
2012-12-24
2,333 reads
2012-10-15
2,299 reads
2012-10-08
2,473 reads
Blogs
Friday Flyway Tips–Comparison Options
By Steve Jones
Recently a customer asked how they could get index changes to be captured in...
A New Word: Guiltwrights
By Steve Jones
giltwrights – n. the imaginary committee of elders that keeps a running log of...
Becoming Kristyna Ferris <3
By DataOnWheels
Hey folks, fun personal post today. A few weeks ago, I got married! My...
Forums
PostgreSQL authenticated against Microsoft Active Directory
Can I authenticate with Active Directory and get into PostgreSQL? Version: PostgreSQL 16.1 on...
Compare all tables row counts for 2 server instances?
USE [DBName] SELECT QUOTENAME(SCHEMA_NAME(sOBJ.schema_id)) + '.' + QUOTENAME(sOBJ.name) AS [TableName] , SUM(sPTN.Rows) AS [RowCount]...
Backing Up Master
Comments posted to this topic are about the item Backing Up Master
Ask SSC