DLP Technology
Steve Jones isn't talking about his new television, but rather a new technology dealing with data and databases.
Intrinsic Member Properties: The MEMBER_VALUE Property
MSAS Architect Bill Pearson leads hands-on exercises providing exposure to the use of the MEMBER_VALUE intrinsic member property. Join us in generating simple lists, as well as datasets to support report parameter picklists.
Scheduling Jobs in SQL Server Express
As we all know SQL Server 2005 Express is a very powerful free edition of SQL Server 2005. However it does not contain SQL Server Agent service. Because of this scheduling jobs is not possible. So if we want to do this we have to install a free or commercial 3rd party product. This usually isn't allowed due to the security policies of many hosting companies and thus presents a problem. Maybe we want to schedule daily backups, database reindexing, statistics updating, etc. This is why I wanted to have a solution based only on SQL Server 2005 Express and not dependent on the hosting company. And of course there is one based on our old friend the Service Broker.
Face to Face
The cost of fuel is rising, telecommuting is becoming more widespread, and the advance of digital technologies has us often working virtually, even in the same office. Steve Jones thinks we shouldn't forget the value of a little face time and and then.
Good Data Loss - Database Weekly (Sept 22, 2008)
As we retain more and more data, it becomes important not just to decide how long to retain different types of data, but also to identify that data that can be removed. Steve Jones talks about some of the challenges of this with databases.
Blog: Cross Functional Teams & Cross Training
Cross functional teams sounds a lot like a buzzword, and maybe it is to a degree - but still worth talking about and I have a short story to support it.
Kalen Delaney: Geek of the Week
Kalen Delaney has been involved in SQL Server from the beginning. Her talks and her writings are always interesting but, most important of all, she was able to successfully take on authorship of the 'Inside SQL Server' series of books from Ron Soukup, and make them her own. Despite her own protests that she is a trainer first and foremost, she richly deserves our accolade of 'Geek of the Week'.
Performance tuning through memory and CPU
In this tip, learn how memory allocation and CPU processing impact SQL Server performance and get tips for tuning these areas.
The Agile Cult
Lots of developers have embraced Agile development, and Steve Jones thinks it's a good way to build software. However, it's not necessarily as easy as you might think.
The Agile Cult
Lots of developers have embraced Agile development, and Steve Jones thinks it's a good way to build software. However, it's not necessarily as easy as you might think.
Blogs
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them Introducing PlanTrace — a free, browser-based...
A Cloud Dependency Failure from Amazon
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
Deploying AI in logistics (the unfiltered version)
A conversation with Jan Laš, CIO at HOPI, about what deploying a data agent...
Forums
BCA KCP Jembatan Lima HUB/CS 08216977701
Jl. KH.Moh.Mansyur No.15 F, Duri Pulo, Kecamatan Gambir, Kota Jakarta Pusat, Daerah Khusus Ibukota...
BCA KCP Pandanaran Telp/wa 085169998765
Telp/wa 085169998765 No. 101 A, Jl. Pandanaran, Mugassari, Kec. Semarang Sel., Kota Semarang, Jawa...
BCA KCP Kas Thamrin City HUB/WA 08216977701
Tower, Apartemen Cosmo Terrace, Gd Thamrin City Lt Dasar 1, Jl. M.H. Thamrin Boulevard...
Question of the Day
Creating a JSON Document III
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT TOP 2
json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers