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.
By James Serra
What problem is Fabric Ontology trying to solve? For years, most data conversations have...
By Steve Jones
Recently I ran across some code that used a lot of QUOTENAME() calls. A...
By ChrisJenkins
There are some telltale signs that your growing business has outgrown Excel for your...
WhatsApp:083179431313 Jl. Cempaka No.17, Sukorejo, Kec. Sukorejo, Kota Blitar, Jawa Timur 66111
WhatsApp:083179431313 Jl. Dr. Soetomo No.118, Darmo, Kec. Wonokromo, Surabaya, Jawa Timur 60241
WhatsApp:083179431313 Jl. KH. Wahid Hasyim No.20, Jombang, Kec. Jombang, Kabupaten Jombang, Jawa Timur 61415
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