Getting TEXT, NTEXT and IMAGE columns in Database
As per Microsoft documentation these types will be removed from future version
2017-06-02 (first published: 2017-05-31)
2,895 reads
Converting values into Rows
Script describe one of the way to divide values into rows by using any specified dividing value.
2016-11-15 (first published: 2016-11-04)
829 reads
Getting top ranked employee detail for each department
Using OVER clause with ROW_NUMBER() function to get top ranked employee detail as per each department.
2016-10-25 (first published: 2016-10-03)
774 reads
SQLCMD to export data in txt file
SQLCMD is one of many methods to export your database data to some text file
2016-10-12 (first published: 2016-09-27)
22,064 reads
Handling with currently running and blocking sessions
Checks currently running sessions and blocking queries with session information
2016-10-05 (first published: 2016-09-16)
791 reads
2016-07-05 (first published: 2016-05-26)
4,861 reads
2016-07-01 (first published: 2016-05-24)
654 reads
Getting LEAD and LAG values manually
LEAD and LAG functions are new in SQL Server 2012 , This short Script could be used to get these values in Earlier versions also
2016-06-28 (first published: 2016-05-18)
787 reads
Table Comparison Procedure
Procedure to compare two tables , getting table names and rows to display
2016-06-07 (first published: 2016-05-06)
1,048 reads
Blogs
Future-Proofing: How to Stay Ahead in FinOps
By HeyMo0sh
Cloud environments don’t sit still. Pricing models change, services evolve, workloads grow, and suddenly...
Introducing the SQL Server on Kubernetes Operator
Are you considering replatforming your SQL Server workload due to recent vendor changes, but...
Advice I Like: Rewards from Work
By Steve Jones
The greatest rewards come from working on something that nobody has words for. If...
Forums
Removing TDE
Comments posted to this topic are about the item Removing TDE
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...
Question of the Day
Removing TDE
How do I remove TDE encryption of data from database xxx?
See possible answers