How Do We Learn?
With a huge increase in the number of online learning frameworks, Dave Convery wonders how comfortable people are with this new way of polishing their skills.
Relying on Algorithms
Today Steve Jones looks at the way software affects the world and how we might be worried about how things might change in the future.
SSRS Report Content Filtering by User Group
How to get an SSRS user's AD group membership in order to filter report content
Some "Laws" of Software Development
Despite all the advances in software tools, there seem to be several enduring truths about software development. By understaning these 'laws', Ziv’s law, Humphrey’s Law and Conway’s Law for example, you can remove some of the mystery of the process. Al Noel discusses these and other laws that seem to apply generally to the art of programming.
SQL Saturday #202 - Edinburgh
Join us for a free day of SQL Server Training on June 8, 2013. There's also a Friday Preconference Training Day with Jonathan Kehayias and Joseph Sack.
Loading XML Data into SQL Server (SQL Spackle)
Learn how to load data in an XML file into a table in SQL Server.
The Bicentennial
Tomorrow is the bicentennial SQL Saturday event. SQL Saturday #200 takes place in Philadelphia, and Steve Jones has some thoughts as he travels to the City of Brotherly Love.
Why is your ASP.NET application running slow?
Any queries run against SQL Server or Oracle databases are recorded, along with how many times those queries were run and how long they took. That information is shown alongside your .NET code, so you can quickly see why the code you wrote resulted in those queries being executed. This can be particularly powerful if you’re using ORMs like Entity Framework to access data, which tend to be an impenetrable black box where performance issues can arise, but where it’s difficult to understand why.
Show off your Solutions
We're looking for scripts that you use in your daily job to find, fix, and solve issues in your environment.
Super Fast Transactional Replication Repair
Your production SQL Server transactional replication just failed and the business impact is critical. How do you get replication restored in minutes?
Blogs
T-SQL Tuesday #202 SQL Server Outage You’ll Never Forget: A Roundup
When I put together the invitation for T-SQL Tuesday #202, I wasn't sure what...
A Last Minute Trip to the EU
By Steve Jones
My life has some crazy travel stretches for sure. Between speaking, office visits, customer...
Part 3 of 3: Tuning DiskANN — R, Alpha, L, Beam Width, Recall and Latency
In Part 1, we saw how ‘Vamana’ represents vectors as nodes, connects them with...
Forums
BCA KCP Pasar Kebayoran Lama Telp:0821-8200-174
Telp/Wa 62 8218200174 Jl. Raya Kby. Lama No.174, RT.8/RW.3, Cipulir, Kec. Kebayoran Lama, Kota...
ALAMAT BCA KCU SCBD Telp/Wa:0821-8200-233
Tlp Cs Bca 08218200233 Equity Tower, Ground Floor, Unit D & Lantai 8, Unit...
Alamat BCA KCP Mayestik Telp/Wa:0821-8200-2031
Phone Cs 08218200203 Jl. Kyai Maja No.77, RT.12/RW.3, Gunung, Kec. Kby. Baru, Kota Jakarta...
Question of the Day
ORDER BY alias
There is a table tmp_tab:
CREATE TABLE tmp_tab ( id int, val int );
INSERT INTO tmp_tab VALUES (1, 1), (2, NULL), (3, 3), (4, 4), (5, 5);You want to order the rows ids by the following expression:
ISNULL(val, id) + 1Which of the following queries produces the expected ordering and why? (Select all correct) See possible answers