In the fourth level of our Stairway to SQLCLR series we take a detailed look at the EXTERNAL_ACCESS and UNSAFE permission sets. We also explore some differences between using TRUSTWORTHY or an Asymmetric Key.
Chris Date is famous for his writings on relational theory. Chris took on the role of communicating and teaching Codd's relational theory, and reluctantly admits to a role in establishing SQL as the dominant relational language. Richard Morris interviews the well-known author and computer scientist.
Introduction of how to design a star schema dimensional model for new BI developers
Software estimates are often wildly off from the actual amount of time and resources that are required. Today Steve Jones looks at a few reasons why.
SQL Server Live! is designed to finely tune the skills of DBAs, developers, Business Intelligence specialists (just to mention a few) with five days of workshops, deep dives and breakout sessions from November 17 - 21 2014.
Have you ever wondered why the transaction log file grows bigger and bigger? What caused it to happen? How do you control it? How does the recovery model of a database control the growing size of the transaction log? Read on to learn the answers.
Our Question of the day is very popular, but we're looking for more complex questions
In this chapter we will learn how to automate Data Mining Tasks using the SQL Agent.
In this chapter we will learn how to automate Data Mining Tasks using the SQL Agent.
The configuration of server systems matters. Not just to ensure software runs smoothly, but also for security.
Every PostgreSQL migration eventually hits the same fork in the road. The database is...
By Steve Jones
I’m off on vacation today. Which is a little weird as I just got...
By Arun Sirpal
Every DBA has a box like this. Sitting untouched for months. Nobody’s proud of...
Comments posted to this topic are about the item Have you done a Mid...
Comments posted to this topic are about the item From SQL Server On-Premises to...
Comments posted to this topic are about the item Independence Day 2026
In the original Independence Day movie (1996), what type of computer did Jeff Goldblum use to connect to the alien mainframe? Take a guess, don't look it up or ask AI.
See possible answers