| A community of more than 1,600,000 database professionals and growing |
| | | Innovation Needs Information We are great about sharing knowledge in the technical community. I think the SQL Server community is even better than most technologies as we do a good job of doing so without the rude RTFM that I find in other communities. However, overall we share lots of information with others. I do know that many other communities are catching up and I really appreciate the answers I've gotten from others when trying to repair my tractor or auto. As the world looks to bring innovative solutions to various problems, it seems that machine learning will play some role. There are some amazing advances taking place in all sorts of areas, and certainly no shortage of organizations that are trying to see if ML enhancements will improve their capabilities. We hear about ML all the time as data professionals, and some of you are starting to try and use these algorithms to build new applications. I ran across a great post about innovation that notes that the fuel for ML and related technologies is data. It's important for training and evaluating systems, and there are companies making a lot of money providing training data. However, there is also lots of data inside companies, especially some of the big social media and communication companies that gives them an advantage. I think that's OK, after all, these companies have innovated to build large scale enterprises and devoted resources to collecting data. However, I do think that more and more data is needed, and companies will work to collect it if they can. That means more and more of us will manage additional data, all of which needs to be cleansed, stored, managed, and protected. More work for us, but also lots of opportunity. Especially if you learn how to process data in new ways. Steve Jones from SQLServerCentral.comJoin the debate, and respond to today's editorial on the forums |
| | The Voice of the DBA Podcast Listen to the MP3 Audio ( 2.9MB) podcast or subscribe to the feed at iTunes and Libsyn. The Voice of the DBA podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. |
|
|
|
| | ADVERTISEMENT | | | | Become a more efficient SQL developer with SQL Prompt Learn how to write SQL faster and more efficiently with these exclusive short videos from Data Platform MVPs and SQL Server experts. With SQL Prompt you can strip out the repetition of coding and write SQL 50% faster. Check out the tips |
| | | | How to track every change to your SQL Server database See who’s changing your database, alongside affected objects, date, time, and reason for the change with SQL Source Control. Get a full change history in your source control system. Learn more |
|
|
|
| | | | | Steve Jones from SQLServerCentral.com Everyone needs to learn about these hardware bugs and apply patches as soon as possible. More » |
| | Brent Ozar opens up the Stack Overflow database, turns on actual execution plans, and runs a query that will cause SQL Server to beg and plead for an index. More » |
| | Microsoft MVP Grant Fritchey, and Redgate’s Arneh Eskandari, will show you how Redgate’s Database DevOps solution works to improve your database development and deployment processes. You'll see a demo of tools from Redgate's SQL Toolbelt and see how they plug into GIT, Jenkins and Octopus Deploy. There will also be plenty of time to ask Grant and Arneh questions. More » |
| | SQLRUs from SQLServerCentral Blogs Recently, I got to work with a client on something interesting. We implemented transactional replication to send data to an... More » |
| | Lincoln Burrows from SQLServerCentral Blogs SQL Server is one of the finest database management system deployed by organizations for storing and retrieving their data. It... More » |
|
|
| | | Today's Question (by Steve Jones): I have a database with 2 data files. I discover that the performance of this database is very poor as the anti-virus software is freezing access to one of the files. I determine that one file has the name "salesdata.nd". Since ".nd" isn't excluded from AV protection, this is causing me issues. What should I do to rename this file? |
Think you know the answer? Click here, and find out if you are right. We keep track of your score to give you bragging rights against your peers.
This question is worth 2 points in this category: Administration. We'd love to give you credit for your own question and answer.
To submit a QOTD, simply log in to the Contribution Center. |
|
|
| |
| ADVERTISEMENT | | T-SQL Querying (Developer Reference) Squeeze maximum performance and efficiency from every T-SQL query you write or tune. Four leading experts take an in-depth look at T-SQL’s internal architecture and offer advanced practical techniques for optimizing response time and resource usage. Get your copy from Amazon today. | |
|
|
|
|
|
|
| Yesterday's Question of the Day |
| Yesterday's Question (by Steve Jones): I've got this table and data: CREATE TABLE TheCounts ( intcol INT , charcol CHAR(10) , varcharcol VARCHAR(100) , datecol datetime2 ) GO INSERT TheCounts VALUES (1, 'West', 'Denver Broncos', '2018-01-01') , (2, 'West', 'Oakland Raiders', '2018-01-01') , (3, 'West', 'Los Angeles Chargers', '2018-01-01') , (4, 'West', 'Kansas City Chiefs', '2018-01-01') , (5, 'South', 'Jacksonville Jaguars', NULL) , (5, 'South', NULL, '2018-01-02') , (6, NULL, 'Indianapolis Colts', NULL) , (7, NULL, 'Houston Texans', NULL) , (NULL, 'North', 'Pittsburgh Steelers', NULL) , (NULL, 'North', 'Baltimore Ravens', '2018-01-03') , (NULL, 'North', 'Cincinnati Bengals', NULL) , (NULL, 'North', 'Cleveland Browns', NULL) , (13, 'East', 'Cleveland Browns', '2018-01-04') , (13, 'East', 'Cleveland Browns', '2018-01-04') , (14, 'East', 'Cleveland Browns', '2018-01-04') , (14, NULL, 'Cleveland Browns', NULL) What do I get when running this code? SELECT COUNT(DISTINCT charcol) FROM dbo.TheCounts AS tc
Answer: 4 Explanation: The answer is 4. There are 4 distinct values in the charcol column. These are: West, South, North, East. The NULLs are not counted. Ref: COUNT() - click here The COUNT Functionin T-SQL - http://www.sqlservercentral.com/articles/T-SQL/142568/ » Discuss this question and answer on the forums |
|
|
| Database Pros Who Need Your Help |
| | Here's a few of the new posts today on the forums. To see more, visit the forums. In-Memory tables candidte - Hello All, how can i decided which table is candidate from disk table to in-memory table? and how can i decide which... In-Memory tables candidate - Hello All, how can i decided which table is candidate from disk table to in-memory table? and how can i decide which... AlwaysON AG in SQL serer 2012 - Hi All, I'm planning to setup AlwayON AG top of fail-over cluster feature enabled for two node replicas. Can you please suggest... Zip XML data - Hi Experts, We are creating an archival plan for one of our table which stores json data in nvarchar(max). We planned... Stored Procedure Dynamic SQL using sp_executesql Not working - I can successfully run a Stored Procedure (SP) that uses dynamic SQL and Exec sp_executesql in my local environment. But... «????????»??????????????????????Q/?:936794295 ????????????????????????????????????????????????????????????1:1???? - ????:David Q/?:936794295 ??????????:????????????(??,??,???,??,???,???,??,??,??,???,???,??,?????)???????,????,????????,????????,????,??????????,????? ??????????: 1????+???+????????+?????,?????,???(????????????,??????????????); 2??????,OFFER,????,??????????(???????,????????????)? ?:??????,?????????,??????,??,??,??,???????????????? ??????: 1?????????; 2????????; «????????»??????????????????Q/?:936794295 ????????????????????????????????????????????????????????1:1????University of Illinois - ????:David Q/?:936794295 ??????????:????????????(??,??,???,??,???,???,??,??,??,???,???,??,?????)???????,????,????????,????????,????,??????????,????? ??????????: 1????+???+????????+?????,?????,???(????????????,??????????????); 2??????,OFFER,????,??????????(???????,????????????)? ?:??????,?????????,??????,??,??,??,???????????????? ??????: 1?????????; 2????????; «????????»???????????????????Q/?:936794295 ?????????????????????????????????????????????????????????1:1????Edith Cowan University - ????:David Q/?:936794295 ??????????:????????????(??,??,???,??,???,???,??,??,??,???,???,??,?????)???????,????,????????,????????,????,??????????,????? ??????????: 1????+???+????????+?????,?????,???(????????????,??????????????); 2??????,OFFER,????,??????????(???????,????????????)? ?:??????,?????????,??????,??,??,??,???????????????? ??????: 1?????????; 2????????; «????????»??????????????????Q/?:936794295 ????????????????????????????????????????????????????????1:1????Charles Sturt University - ????:David Q /?:936794295??????????:????????????(??,??,???,??,???,???,??,??,??,???,???,??,?????)???????,????,????????,????????,????,??????????,?? ??? «????????»????????????????Q/?:936794295 ??????????????????????????????????????????????????????1:1????Murdoch University - ????:David Q/?:936794295 ??????????:????????????(??,??,???,??,???,???,??,??,??,???,???,??,?????)???????,????,????????,????????,????,??????????,????? ??????????: 1????+???+????????+?????,?????,???(????????????,??????????????); 2??????,OFFER,????,??????????(???????,????????????)? ?:??????,?????????,??????,??,??,??,???????????????? ??????: 1?????????; 2????????; «????????»??????????????????Q/?:936794295 ????????????????????????????????????????????????????????1:1????Curtin University of Technology - “????????”??????????????????Q /?:936794295????????????????,?????????????????,???????????,????,????1:1????Curtin University of Technology????:David Q /?:936794295??????????:????????????(??,??,???,??,???,???,??,??,??,???,???,??,???? «????????»??????????????????Q/?:936794295 ????????????????????????????????????????????????????????1:1????Adelaide University - ????:David Q /?:936794295??????????:????????????(??,??,???,??,???,???,??,??,??,???,???,??,?????)???????,????,????????,????????,????,??????????,?? ??? «????????»???????????????????Q/?:936794295 ?????????????????????????????????????????????????????????1:1????James Cook University - ????:David Q /?:936794295??????????:????????????(??,??,???,??,???,???,??,??,??,???,???,??,?????)???????,????,????????,????????,????,??????????,?? ??? «????????»???????????????????Q/?:936794295 ?????????????????????????????????????????????????????????1:1????Swinburne University of Technology - “????????”???????????????????Q /?:936794295????????????????,??????????????????,???????????,????,????1:1????Swinburne University of Technology????:David Q/?:936794295 ??????????:????????????(??,??,???,??,???,???,??,??,??,???,???,??,?????)???????,????,????????,????????,????,??????????,????? ????????? In place OS upgrade of one node cluster - I currently have a one node cluster running Windows Server 2012 Standard and SQL Server 2012 standard. It is one... TSQL Help - Hello, I was tasked with deploying a solution to monitor "Daily Activity Frequency" in Sales Person, Region and Team level. I... DDL Trigger to Track All Database Changes? Permissions - Looking to implement the server level trigger below to track all DDL changes in the instance. How do I get... Avoid Statement Termination due to possible string truncation. - Hi, "string or binary data would be truncated. the statement has been terminated" This is a very common error about possible truncation... opening a rowset failed - hi i have ssis package , loading data from excel file into sql server table. package is working fine if I execute in SSDT when... T-SQL Equivalent to Oracle TRANSLATE - Hi, everyone. I'm converting a SQL script from our old Oracle-based Lawson application to our new SQL Server-based PeopleSoft app. This... |
|
| This email has been sent to [email protected]. To be removed from this list, please click here.
If you have any problems leaving the list, please contact the [email protected]. | This newsletter was sent to you because you signed up at SQLServerCentral.com.
Feel free to forward this to any colleagues that you think might be interested.
If you have received this email from a colleague, you can register to receive it here. | This transmission is ©2018 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: [email protected] |
|
|
