SQL Server may not be the best solution for every problem, but we have the means to extend its capabilities by linking it to external resources; in this case, using SQLCLR to query a graph database.
2014-01-08
9,290 reads
This article describes how to use the new wizards in SQL Server Management studio to get access to Windows Azure and then create and configure your VM.
2014-01-08
3,114 reads
Paul Brewer talks about an AlwaysOn problem affecting the Service Broker Transmission Queue.
2014-01-07
4,474 reads
Graph database are an intriguing alternative to the relational model. They apply graph theory to record the relationships between entries more naturally, and are a good fit for a range of data tasks that are difficult in SQL. Buck Woody gives an introduction to Graph databases and shows how to get Neo4J up and running to get familiar with the technology.
2014-01-07
3,331 reads
When you need to find all the related rows and tables to a parent table, here's one way you might approach the problem.
2014-01-06
8,196 reads
You need a SQL Server-based application that will work with huge amounts of data and must perform calculations of startling complexity. How far will you go to deliver the required performance?
2014-01-06
175 reads
You have imported an assembly into a SQL Server database to use the CLR functions and stored procedures it contains. However later, you lost the original .dll file and you would like to create the .dll file again from what's in the database. In this tip, we look at how you can recreate the .dll file.
2014-01-06
2,453 reads
SQL Saturday is coming to Albuquerque on January 25, 2014. Join us for a free day of SQL Server training and networking. This SQL Saturday also features 2 paid-for preconference sessions presented by Denny Cherry and William E. Pearson III.
2014-01-06
1,658 reads
Red Gate are looking for participants in a short short survey on SQL Server database releases. At the end you will be given a chance to enter an e-mail address to win a $50 Amazon gift certificate.
2014-01-06 (first published: 2013-12-20)
3,629 reads
Receive Deadlock info from the SQL Error Log every time a deadlock occurs.
2014-01-03 (first published: 2010-12-13)
55,222 reads
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Wa 087878229292 Jl. Gatot Subroto KM 3 RT 003 RW 009 Kec. Cibodas, Kota...
Whatsapp:08216977726 Jl. Trans Sulawesi, Keurea, Kec. Bahodopi, Kabupaten Morowali, Sulawesi Tengah 94974
WhatsApp 083135766741 Jl. Pegirian No.114, RT.007/RW.10, Sidodadi, Kec. Simokerto, Surabaya, Jawa Timur 60145
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers