Your Best Work
Interviewing people is hard to do well. Steve Jones talks about a technique that might help you better choose good employees for your organization.
Using Stored Procedures to Provide an Application’s Business-Logic Layer
When faced with a complex business application, Dwain's team chose to encapsulate and implement most of an application’s business logic in SQL Server, using an interface made up of stored procedures. Here's how they did it.
Personal Development
Steve Jones thinks that a personal development plan is important and talks today a little about how you should build one.
Guidelines for Using Natively-Compiled Stored Procedures in SSIS Packages
As you may know, SQL Server In-Memory OLTP introduced in SQL Server 2014 offers great performance improvements for ETL processes. In this tip we cover techniques you need to know about various behaviors of SQL Server In-Memory OLTP depending on the options you select.
Minimal Meetings
Too many meetings happen in software teams. Steve Jones says that when scheduling meeting, you should be aware of the cost, and only include those people that need to be there.
Templates and teamwork
SQL Server expert David Poole discusses how teams can work together and share templates in Management Studio.
Explaining The SQL Server 2014 Analysis Services Data Mining Model Lift Chart
In this tip, Dallas Snider explains how to interpret the Lift Chart found on the Mining Accuracy tab of a SQL Server 2014 Analysis Services Data Mining structure.
SSIS 2012 Projects: Deployment Configurations and Monitoring
The Project Deployment Model introduced in SSIS 2012 speeds up the deployment of database projects in which there may be hundreds of SSIS packages per project. Not only that, but deployments can be configured differently for each environments such as test and staging, and there are now ways of monitoring the status and performance of packages and of versioning the SSIS Catalog.
Blogs
Optimizing Redshift Performance by Configuring WLM Queues
Efficient query performance in Amazon Redshift often comes down to how well you manage...
PowerShell Strikes Back: Return of the Loop
By gbargsley
Welcome back to PowerShell Strikes Back. We’re three weeks in, and the training is...
Breaking Rules in Rome
By Steve Jones
Last week I was honored with a trip to Rome for the Redgate President’s...
Forums
Dealing with huge heap tables
Recently, our dev teams approach me for advice on improving their huge heap table...
BCA KCU GAJAH MADA No.Telpon 087781685647
Whatsapp 087781685647 Jl. Gajah Mada No.112 B-C-D, RT.1/RW.1, Krukut, Kec. Taman Sari, Kota Jakarta...
Merge Replication failing with Error converting data type nvarchar to numeric
After upgrading 2 Merge Replicated databases to SQL 2022 and re-establishing the Merge Replication...
Question of the Day
Distance Metric Algorithms
What are the distance metric algorithms that can be used in VECTOR_DISTANCE()?
See possible answers