Useful Tsql Queries And Scripts To Work In Sql Server | Latest News RSS feed

Useful Tsql Queries And Scripts To Work In Sql Server - Latest News


Useful T-SQL queries and scripts to work in SQL Server

This post is about some queries and scripts that I use in my daily work on SQL Server. Some of them are self-explanatory, i.e. the name of the query/script already describes its purpose. However, if y... read more

Working with substitution variables and using EXECUTE IMMEDIATE in PL/SQL

Substitution variables only work in SQL*Plus or SQL*Worksheet, because those tools know about substitution variables. This is OK for a one-off script you're ... a concrete sample query and test it to ... read more

Accessing a Data Flow Object From a Script in MS SQL SSIS

SQL Server ... script task in an SSIS work flow, you can directly access data from a data flow. In this sense, you are actually handling data programmatically during data transfer. In order to manage ... read more

Looking for another news?


Collection: SQL Server Sample Databases

Why create a whole database when you can use an existing ... There is also a sample script of how to create it. Since the script is simple enough, it should work on every SQL Server. read more


SQL Server 2019 CTP 2.1: A first look

Adding container support, using Docker and the Linux version of SQL Server, is an interesting option as it will allow you to build SQL Server into massive Kubernetes-based analytic engines that work . ... read more

SQL Server Vulnerability Assessment

SQL Server Vulnerability ... rule not followed and provides us a query that we can run to see the results. I really like this feature and it’s a handy script to keep for later use when evaluating anot... read more

Best SQL Books

So what are the top SQL books for today? SQL: The Complete Reference, Third Edition shows you how to work ... queries, tune performance, and implement reliable security policies. Learn how to employ D... read more

Improvements Coming to Azure SQL, SQL Server 2019 Preview

SQL Server ... use of Apache Kafka on Azure in this way because organizations won't have to bother with configuring it, nor will they have to manage servers or networks. Organizations won't have to ch... read more

Build and Fill a Database Using JSON and SQL Change Automation

We can use CSV, but SQL Server is puzzlingly bad at CSV ... This is said to work but doesn't: In this example script, I've given the information for the databases, servers, and login in a ... read more

Free Alternatives to SQL Server Management Studio

There are some nifty, better-than-SSMS tools that cost nothing to use. One of them is ... To get started running scripts, you have to change the default execution policy, as explained here. Then, to w... read more

FAQ: SQL Server query errors and explanations

Queries in SQL ... generic database scripts to be written for large installations. There is not enough space here to properly cover this tool; please consult SQL Server 2005 Books Online for a complet... read more

Microsoft SQL Operations Studio eases SQL Server admin tasks

Microsoft SQL ... server dashboard, for example, users can restore and search databases or launch database dashboards. On the latter, they can back up databases, search tables, generate table creation ... read more



FeedsRSS Created by. Full RSS Feed | Privacy Policy | Contact Us