SQL Server String Manipulation using Substring Function in T-SQL, R and Python
In this tip we look at how to use substring functions or similar using T-SQL, R and Python when working with SQL Server.
2019-05-31
Additional Articles
Bloor 2019 Market Update on Test Data Management
Discover the latest market trends and assess your approach to test data management. For example, the Bloor analyst recognizes “…an increased emphasis on test data provisioning, as opposed to merely test data management.” The report also covers key capabilities offered by vendors in the market, including Redgate.
2019-05-30 (first published: 2019-05-16)
Enhance your database development by using coding standards
Establishing coding standards can help remove blockers to understanding code, improving quality and reducing maintenance. Faris Hilmi explains how having consistently formatted code plays a larger role in database development and how Redgate tools can best equip you for the task.
2019-05-30
What is Automation?
Kendra Little looks for a meaningful definition of automation as it applies to the software development process.
2019-05-30
4 steps to standardize your database development processes
Adopting standardized processes in database development can free up the time of development teams for innovation and value adding work. Find out the 4 steps you can take to lay the foundations for standardized development in your team and pave the way for full automation.
2019-05-29
SQL Server Triggers Pros and Cons
In this tip we look at some of the advantages and disadvantages of using triggers in SQL Server.
2019-05-29
How to Reseed Your Identity Column Value in SQL Server
Have you deleted a bunch of rows from a table that has an identity column value and now thins aren't working quite right? If so, read on...
2019-05-28
Insert Statement Without Column List (BP004)
Many production databases have failed embarrassingly as a result of INSERT code that omits a column list, usually in mysterious ways and often without generating errors. Phil Factor demonstrates the problem, and advocates a 'defense-in-depth' approach to writing SQL, in order to avoid it.
2019-05-28
Streamlining a Power BI Solution
Power BI is an excellent tool for departments or small organisations getting started with their BI solution. Unless some time is spent organising the solution, however, it can become cluttered. In this article, Gogula Aryalingam explains how to streamline the solution to keep it organized and efficient.
2019-05-27
The Sins of SELECT * (BP005)
If Prompt warns you of use of the asterisk, or 'star' (*), in SELECT statements, consider replacing it with an explicit column list. It will prevent unnecessary network load and query performance problems, and avoid problems if the column order changes, when inserting into a table.
2019-05-27
Blogs
The Azure-SSIS IR Startup Time
If you want to run SSIS packages in Azure Data Factory, you need the...
What is a container anyway?
Recently there was a thread on Twitter which established that a lot of IT...
Comparing Execution Plans
When you run a query twice, and get dramatically different run times, your first...
Forums
Statistics Profile Results
Comments posted to this topic are about the item Statistics Profile Results
DW create User for DB Owner
we have created Data warehouse server and planning to create Databases, Schema and users....
Optimize a stored procedure
I have a stored procedure that is called multiple times to get all the...
Ask SSC