Be Reasonable
Be reasonable. That's how Steve Jones thinks managers ought to behave towards their employees.
How to use temporary table in function
See a short and dirty example how to use temporary table in user defined function (UDF).
URI Parser: A set of 20 CLR functions for URI parsing
A set of 20 functions for URI and URL parsing, using .NET's native System.Uri parser
Managing SQL Server Service Broker Environments
SQL Server Service Broker (SSBS) is a new architecture (introduced with SQL Server 2005 and enhanced further in SQL Server 2008 and later versions) that allows you to write asynchronous, decoupled, distributed, persistent, reliable, scalable and secure queuing/message-based applications within the database itself. Arshad Ali looks at how we can manage, monitor and troubleshoot Service Broker environments.
PASS Data Architecture Present Microsoft – Readying on ‘Hadoop’
On Thursday July 20th, MCM Gaurav Aggarwal will provide an overview of the different options on MS platform for Hadoop
SQLServerCentral Webinar Series #11: A Sandbox Development Process
Steve Jones is your host introducing Grant Fritchey who'll present this webinar. This session explores the use of two Red Gate products, SQL Virtual Restore and SQL Source Control, in establishing a well-defined development process that allows for the use of known data sets and source code management of your database code. These tools work together to help you create a sandbox environment where you can test and develop your databases. Working with a development process is the best way to ensure a safe deployment process to protect your production systems.Developing software without establishing a good process can be a situation rife with the possibility of disaster.
I Want Stupid Employees
Why don't employers want to fund training? Steve Jones has a few thoughts after a great piece that shows the lack of wisdom in withholding training.
Stairway to SQL Server Replication - Level 5: Transactional Replication & How it works
This level covers the details of SQL Server transactional and merge replication, from understanding the basic terminology and methodology of setting up replication, to describing how it works and how the basic replication processes can be monitored.
Arrays in SQL that Avoid Repeated Groups
It is certainly possible to fake an Array in SQL, but there are only a few occasions when it would be the best design. Most often, the wish for an array in SQL is a sign of a forlorn struggle against poorly-normalised data. One of the worst sins against Codd is the repeating group, as Joe Celko explains.
Fitting In
Today we have a guest editorial from Andy Warren that talks about fitting in at work and conforming to the expectations of the group and that environment.
Blogs
T-SQL Tuesday #198 Roundup: How Do You Detect Data Changes?
Thank you to everyone who participated in T-SQL Tuesday #198! When I wrote the...
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...
Forums
BCA KCU CITY TOWER No.Telpon 087781685647
Whatsapp 087781685647 Jl. M.H. Thamrin No.81 Ground Floor, RT.1/RW.6, Dukuh Atas, Menteng, Kec. Menteng,...
BCA KCU SCBDTelepon083179431638
WhatsApp083179431638Equity Tower, Ground Floor, Unit D & Lantai 8, Unit E, Jl. Jenderal Sudirman...
BCA KCU KUBU RAYA No. telp:087757645171
Whatsapp:087757645171 W979+XMQ, Jl. Arteri Supadio No.Kel, Sungai Raya, Kec. Sungai Raya, Kabupaten Kubu Raya,...
Question of the Day
QUOTENAME Quote Parameters
When I use QUOTENAME(), I can optionally provide the character used to surround the string in the result. Can I use any character?
See possible answers