Single Quotation Marks in SQL
One of the common problems is dealing with apostrophes in T-SQL. This article examines the challenges of single quotation marks and ends with a short quiz.
Do You Really Need to Tune Big Data Applications?
Big data applications are here to stay. The promise of this technology is the ability to quickly and easily analyze large amounts of data and derive from that analysis changes to customer-facing systems, hopefully at a reasonable cost. So, do these applications really need tuning?
Instant File Initialization
This article describes a way to speed up various file operations performed by SQL Server.
Is It Time To Clear Out Those Quirky Functions?
Phil Factor ponders a cull of some of SQL Server's worst-behaving functions.
Agile 2014, Florida
Agile Alliance is holding a conference July 28 - August 1 in Orlando, Florida. If you're interested in Agile development, whether your initiative is mature or brand new, enterprise-wide or team-centric, you will find the finest knowledge, resources and people at Agile2014. This conference is for Teams, Developers, Managers and Executives. Register while space is available.
The Mindset of the Enterprise DBA: Creating and Applying Standards to Our Work
Although many professions require judgement and skill, they also require the ability to do many repeated standard procedures in a consistent and methodical manner. For DBAs, standardization involves providing and following checklists, notes and instructions so that the results are predictable, correct and easy to maintain.
Microsoft Azure Diagnostics Part 2: Basic Configuration of Azure Cloud Service Diagnostics
Michael Collier takes a look at the key aspects of configuring the diagnostic agent in Microsoft Azure to collect the data you want, and transfer that data to storage on a schedule you define.
Dynamic Management Views: Changes in SQL Server 2014
SQL Server 2014 has a number of new DMVs, and some changes from SQL Server 2012. What are the new views and changes, and how can be useful to you?
Never give up
When facing a problem you aren't sure you can solve, keep working on it and believe in yourself.
Rollback and Recovery Troubleshooting; Challenges and Strategies
What happens if your database deployment goes awry? Grant Fritchey has some troubleshooting advice to get you out of a bind.
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
BCA KCP Jalan Panjang TLP/WA 08216977749
Graha Elok Mas, Jl. Panjang No.79 EF, RT.6/RW.1, Kedoya Sel., Kec. Kb. Jeruk, Kota...
BCA KCP Daan Mogot Dua TLP/WA 08218573837
Jl. Daan Mogot No.48 A, Jelambar, Kec. Grogol petamburan, Kota Jakarta Barat, Daerah Khusus...
BCA KCP NGALIYAN TLP/WA 083800209966
Ruko Ngaliyan Square, Jl. Prof. Dr. Hamka No.17 No. 3A, Purwoyoso, Kec. Ngaliyan, Kota...
Question of the Day
May the Fourth Be With You Fun
In honor of May the fourth and Star Wars (may the force be with you), finish this quote:
"Do, or do not. ..."See possible answers